Attaching SQL Server Configuration Database Using SNMP Connector

To Attach a New SQL Server Configuration Database:

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

Attaching a 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 the Workbench64 and select Attach Database. Other menu options using this method include Make Active, New Database, Delete Database, Detach Database, Connect Database, Disconnect Database, and Upgrade Database.

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

This will bring up the SNMP - Attach 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 - Attach Database Wizard

Then you can locate the database file to attach and provide a name for the database in the Attach as: text entry field. Clicking the ellipsis button [...] opens the Select File window (shown below), allowing you to browse for your desired database file.

Select File window

Click OK once you have located the file. The dialog box closes. Then, in the wizard, click Finish.

Locate the database file to attach

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

New Configuration Database in the Project Explorer