Connecting to an Existing SQL Server Configuration Database

To Connect to an Existing SQL Server Configuration Database Using SNMP Connector:

  1. Right-click on the top level Workbench "server" (for example, "localhost") and select Connect Database. In addition to standard editing commands (Paste, Cut, Copy), you also have the option of refreshing any individual database or parent.

Connecting to an Existing SQL Server Configuration Database through the Project Explorer

 

-OR-

 

Click the Database button in the Edit section of the Home ribbon at the top of Workbench64 and select Connect Database. Other menu options using this method include Make Active, New Database, Delete Database, Attach Database, Detach Database, Disconnect Database, and Upgrade Database.

 

Connecting to a SQL Server Configuration Database through the Workbench Ribbon (Edit Section)

  1. This opens the SNMP - Connect Database Wizard. Use Default SQL Server (recommended) is checked by default. Unchecking this option brings up additional Connection settings, where you may Select the SQL Server using a drop-down list and then decide between using Windows Integrated Security or providing a specific User Name and Password. Make your selection, then click Next to proceed.

SNMP - Connect Database Wizard

  1. You can then select the database file to connect to by using a drop-down list. Make your selection, then click Finish.

Locate the Database File to Connect

  1. Your Connected SQL Server Configuration Database now appears in the Project Explorer under the Workbench server (for example, "localhost").

Connected Server

 

See also:

Creating a New SQL Server Configuration Database

Attaching an Existing SQL Server Configuration Database

Activating the Database

Configuring Databases

SNMP Connector