Activating the Database Using the Web Services Provider

Once your configuration is complete, you may need to make sure that your new/attached/connected database is "Active". The database that is designated as "Active" is the one that the server uses.

 

To Make a Database in the Project Explorer Active:

  1. Right-click on the database icon and select Make Active. If the Make Active selection is grayed out, then the current database is already the active database. You can tell which database is currently active by the nearby Active or Inactive icons.

Making a Selected Database Active Via the Project Explorer

 

-OR-

 

Select the database you intend to make "active" in the Project Explorer. Click on the Make Active button in the Edit section of the Home ribbon at the top of the Workbench.

 

See also:

Creating a New SQL Server Configuration Database

Attaching an Existing SQL Server Configuration Database

Connecting to an Existing SQL Server Configuration Database

Configuring Databases

Web Services Overview