To repair a connection

  1. From the HCO for SQL Server interface, click Manage Connections.
  2. From the Connection List tab, select a Connection Type - System or User - to populate the Connection List grid with connections defined for that type.
  3. From the Connection List grid, select a connection that shows a status other then OK or Unknown for at least one connection type. SQL Server connections indicate status for 32- or 64-bit ODBC and 32- or 64-bit CLR 2 or 4 ADO.NET connection types. DB2 connections show 32- and 64-bit CLR 2 and 4 ADO.NET connection types.
  4. Click Repair.