Database properties and connection information for SQL Server

If you use a SQL Server database and are upgrading to latest version for Windows™, Linux™ and the UNIX™ system, you might need to modify the database properties of your schema repositories and user databases.

Also, if you plan to include clients from different versions in your environment, you might need to change the connection information on older clients to work with the upgraded user databases.

If you use a SQL Server database and have upgraded to version 2003.06.13 or later, you have modified the database properties and do not need to do so when you upgrade to latest version.

For the previous versions, these fields were listed by the Maintenance Tool on the database properties page for SQL Server databases:
  • Vendor (SQL_SERVER)
  • Physical Database Name
  • Database Server Name
  • Administrator Name
  • Administrator Password
  • Read/Write User Name
  • Read/Write User Password
  • Read-Only User Name
  • Read-Only User Password
Beginning with version 2003.06.13 and later, these fields are listed:
  • Vendor (SQL_SERVER)
  • Physical Database Name
  • Database Server Name
  • Administrator Name
  • Administrator Password
  • Connect Options

Fields for Read/Write User Name, Read/Write User Password, Read-Only User Name, or Read-Only User Password have been removed. These fields are not necessary, because they are not required for the latest SQL Server version.

Another important change is the addition of a Connect Options field.

The valid parameters for the Connect Options field are PORT, INSTANCE, and MS_DRIVER. They take the form PORT=number , INSTANCE=name , and 

MS_DRIVER=0 (or unset) - ClearQuest will use the "SQL Server" driver.

MS_DRIVER=1 and Compass will look up for SQL Server Native Client 10.0. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver.

MS_DRIVER=2 and Compass will look up for SQL Server Native Client 10.0. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver.

MS_DRIVER=3 and Compass will look up for SQL Server Native Client 11.0. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver.

MS_DRIVER=4 and Compass will look up for SQL Server Native Client 11.0. 

MS_DRIVER=5 and Compass will look up for ODBC Driver 11 for SQL Server. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver. 

MS_DRIVER=6 and Compass will try to use ODBC Driver 11 for SQL Server.

MS_DRIVER=7 and Compass will look up for ODBC Driver 13 for SQL Server. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver. 

MS_DRIVER=8 and Compass will try to use driver ODBC Driver 13 for SQL Server. 

MS_DRIVER=9 and Compass will try to use driver ODBC Driver 17 for SQL Server. If present, Compass will use that driver, otherwise Compass will use the "SQL Server" driver. 

MS_DRIVER=10 and Compass will try to use driver ODBC Driver 17 for SQL Server.

The names of the options in the Connect Options field are not case sensitive, but the values are. Parameters must be separated by semicolons, with no spaces in between.

Do not enter a value in the Connect Options field if you are going to use the default port number and database instance.