Invalid connection string. You must specify a valid connection string to build or deploy a database project.

This error occurs if you try to build or deploy a database project with an invalid connection string for the target database. To build a database project, you must have a valid connection to determine whether the build script must create or update the database objects.

To correct this error

1. In Solution Explorer, click the database project.

2. On the Project menu, click DatabaseProjectName Properties.

   The properties window for the database project appears.

3. Click the Build tab.

4. In Target connection, click the Browse button.

   The Connection Properties dialog box appears.

5. In Server name, type or click the name of the server that hosts the target database.

6. In Log on to the server, click the authentication method that you want to use. If you click SQL Server Authentication, you must also specify a user name and password.

7. Click OK.

8. On the File menu, click Save Selected Items.

   You can now build or deploy the database project.

See Also

Tasks

How to: Configure Database Projects for Build and Deployment
How to: Prepare Database Build Scripts
How to: Deploy Changes to New or Existing Databases
How to: Create a Database Connection

Concepts

Troubleshooting Data Generation Issues
Terminology Overview of Team Edition for Database Professionals