Creating a New SQL Server Configuration Database Using the Web Services Provider

To Add a New SQL Server Configuration Database:

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 New Database button in the Edit section of the Home Ribbon at the top of the screen in the Workbench. Other menu options using this method include Attach Database, Connect Database, Delete and Refresh.

This will bring up the Create a new Database window. Select the SQL Server and either add a new Database name in the text entry field or select an existing one using the drop-down menu. You can also decide whether to include sample data. You can also make any File Size/Log File Size settings (initial size, file growth, maximum size). Make your selections then click OK to proceed.

Create a new Database Window

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