Error adding connection in Server Explorer: "Unable to add data connection. ExecuteScalar requires an open and available connection."

Question

I'm using Visual Studio 2008, and my database is SQL Server 2000.

I want to add a connection to the Server Explorer in VS. The Data source is Microsoft SQL Server (SqlClient). After entering in all my information and I click Test Connection, it is successful.

But when I click OK, I get the error:

Unable to add data connection. ExecuteScalar requires an open and available connection. The connection's current state is closed.

Answer 1

Restart Visual Studio. Then, restart your computer.