To create a system or user SQL Server connection

Restriction: This topic applies to Windows environments only.

Be sure you have added your SQL Server database to Microsoft SQL Server Management Studio.
From the HCO for SQL Server interface, click Manage Connections.
On the Connection List tab, select a Connection Type - System or User - for this SQL Server connection.
From the Connection List tab, click New SQL Server Connection.
Specify appropriate Connection Properties.
Specify appropriate Data Link Properties as follows:
1. Specify a SQL Server Instance by selecting from the drop-down list, or by typing the name of your SQL Server instance into the field. If you type in the name of your SQL Server instance rather than selecting it from the drop-down list, you must also click Confirm Server.
2. If you want to use a database other than the default database, check Use a database other than the default database: dbname, and then select an alternative database from the Database drop-down list.
Click Test.
When the connection tests successfully, click OK to clear the message.
Click Save.
The new connection appears on the Connections List located on the Connections List tab.