Database properties and connection information for SQL Server

If you use a SQL Server database and are upgrading to version 7.1.x from any version earlier than 2003.06.13 for Windows or clearquest_p2003.06.00-6 for 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 version 7.1.x.

In releases earlier than version 2003.06.13, these fields were listed by the Maintenance Tool on the database properties page for SQL Server databases:
Beginning with version 2003.06.13 and later, these fields are listed:

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 SQL Server version 7.0 and later.

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

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

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.


Feedback