Attaching SQL Server Configuration Database Using the Web Services Provider 

To Attach a New SQL Server Configuration Database:

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

  1. This will bring up the Attach a Database window. You can select the SQL Server using a drop-down list and enter a file name in the text entry field or click on the ellipsis button [...] to browse for the database file. You can also name the database in the 'Attach As' text entry field.. Make your selection, then click OK to proceed.

Attach a Database Window

  1. 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

 

See also:

Creating a New SQL Server Configuration Database

Connecting to an Existing SQL Server Configuration Database

Activating the Database

Configuring Databases

Web Services Overview