How do I set up SQL Server 7 databases with ClearQuest?
• the schema repository or master database, where ClearQuest stores schemas • one or more user databases to contain the data entered into the system by the users of ClearQuest and ClearQuest Web To use SQL Server 7 with ClearQuest, you must first do the following: • Have the SQL Server 7 ODBC driver on your machine. The driver is normally installed automatically with ClearQuest. • Create an empty database in SQL Server for each ClearQuest database desired. (See the next question for details.) You create the master database first, using the ClearQuest Maintenance Tool, option 2. The tool will prompt for three logins, for backward compatibility with SQL Server 6.5. With SQL Server 7, just specify your one login three times (and then similarly two times when creating each user database). Then you log in to the master database with ClearQuest Designer, decide which schema to base your user database on, and choose Database > New Database to create the client user database. 1.3. How do I cre
