To import a connection

From the HCO for SQL Server interface, click Manage Connections.
On the Import tab, type the full path to and filename of an XML (.xml) file containing the exported connection(s) that you want to import, or click the browse button to select a file.
Click Read Available Connections to populate the list.
Select one or more connections to import.
Click Import.
Note:
- If one or more of the selected connections uses a provider other than the Microsoft OLE DB Provider for DB2 or the SQL Native Client, or if you do not have the appropriate database provider installed, the Import button is disabled and you cannot import the connection.
- When importing an OleDb Data Provider connection, whenever possible, HCOSS uses the same driver version that was in use when the connection was exported. For example, if the exported connection used SQL Server Native Client 10.0, and that version is installed and available for the import, HCOSS uses it. If the version specified is not installed or is not available, HCOSS uses the latest version available for that driver.
- HCOSS cannot import a connection that has the same name as an existing connection. In this case, HCOSS notifies you that the connection already exists, and does not perform the import of that connection.
When the import is complete, click OK to clear the message. You should see the imported connections on the Connection List found on the Connection List tab.