Creating a New SQL Server Configuration Database Using SNMP Connector

To Add a New SQL Server Configuration Database:

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

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

 

Creating a New SQL Server Configuration Database Using the Workbench Ribbon (Edit Section)

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

  1. Then, in Change File Settings, you can change the most common database options, including naming the new database, as well as setting database and log file settings. Clicking the ellipsis button […] brings up a secondary box to change size settings (Initial Size, File Growth and Maximum File Size).

Database File Size Settings

  1. Click OK once you have made your database file size changes to close the dialog box, then in the wizard click Finish.

Change the most common database options

  1. Your New SQL Server Configuration Database now appears in the Project Explorer under the Workbench server (for example, "localhost") in the Project Explorer. The database will be inactive until you activate it.

New Database in the Project Explorer

 

See also:

Attaching an Existing SQL Server Configuration Database

Connecting to an Existing SQL Server Configuration Database

Activating the Database

Configuring Databases

SNMP Connector