To edit an existing connection

  1. From the HCO for SQL Server interface, click Manage Connections.
  2. On the Connection List tab, select a connection from the connection list; then click Edit.
  3. Modify the Connection Properties and Data Link Properties as appropriate.
  4. Click Test.
  5. When the connection tests successfully, click OK to clear the message.
  6. Click Save.
Note: When editing a SQL Server connection of the System or User connection type, if HCOSS finds a more recent version of SQL Native Client available on your machine, it prompts you with the option to upgrade the connection to use the updated driver. You can turn this functionality off by unchecking Enable Checking for New ODBC Drivers on the Connection List tab or by checking Stop asking me on the prompt dialog box.