Vendor database properties

When you create a schema repository or user database, you must set the properties for the vendor database.

SQL Server parameters

To specify database parameters for SQL Server:
  1. In the Physical Database Name field, enter the database name for SQL Server schema repository or user database.
  2. Enter the name of the database server in the Database Server Name field. All HCL Compass clients must be able to access this server host name exactly as it appears in this entry.
  3. Enter the database owner (DBO or Administrator) user name in the Administrator Name field.
  4. Enter the password for the database owner (DBO or Administrator) in the Administrator Password field.
  5. Optional: Enter the connect options in the Connect Options field. The supported connect options are INSTANCE and PORT.

    If the SQL Server instance name is different from the default, you can specify the instance in the form INSTANCE=name.

    If the port number of the database is different from the default (1433), enter the port number in the form PORT=number.

    If you use both INSTANCE and PORT, separate the options with semicolons. For example: INSTANCE=MYSQLSERVER;PORT=1400