SQL Server connection information
The following table provides an example of a SQL Server connection created in version 2003.06.00 and earlier. In the example, the schema repository, which is in the max10 database, points to server K123.
| Version 2003.06.00 connection information | Value |
| Vendor | SQL_SERVER |
| Physical Database Name | max10 |
| Database Server Name | K123 |
| Administrator Name | jeff |
| Administrator Password | ******** |
| Read/Write User Name | jeff |
| Read/Write Password | ******** |
| Read-only User Name | jeff |
| Read-Only Password | ******** |
A view of the same connection in the Maintenance Tool in version 2003.06.13 and later:
| Version 2003.06.13 and later connection information | Value |
| Vendor | SQL_SERVER |
| Physical Database Name | max10 |
| Database Server Name | K123 |
| Administrator Name | jeff |
| Administrator Password | ******** |
| Connect Options |
This connection works because the default port value of 1433 is
the same for both versions of HCL Compass. Although the port setting
is not displayed, version 2003.06.13 and later uses the default port. The
default port is established when you install SQL Server. If you are using
another port, you can specify the port number in the Connect Options field
in the form PORT=number.
HCL Compass version 2003.06.13 and later also supports multiple instances. If you want to create more instances of SQL Server on that same host, they become named instances and are assigned unique port numbers. However, only one instance can run on one port.
To use a named instance of SQL server with HCL Compass, you must set either the instance name or the port number in the connect options field using PORT= and INSTANCE=. Do not add the instance name to the server name in the Server field.