Geek Answers Handbook

Create an SQL database and add to the project using Visual Studio

When I go to the "Add New Item" window in Visual Studio 2005 and try to add an SQL database, it freezes a bit and then gives the following error:

When connecting to SQL Server, a network-related or specific instance error occurred. The server was not found or was not available. Verify the instance name is correct and configure SQL Server to connect remotely. (provider: TCP provider, error: 0 - the connection could not be completed because the target machine actively refused it.)

I can use SQL Server Management Studio to connect to localhost (the default instance) is just fine, but Visual Studio should try to connect to another instance (which no longer works). How to change which instance it is trying to connect to in order to add and use a database?

+5
source share
4 answers

It looks like you are trying to add an instance of the SQL Server Express database, but you may not have the service installed or enabled.

+3
source

? 3 , , . , SQL Server , Visual Studio . SQLExpress .

, Visual Studio. , , , , , . . Visual Studio, .

, , , msdn - . ( ), , , viola, . .

+1

node .

0

, ... http://go.microsoft.com/fwlink/?LinkId=49251? VS2005 dev SQL Server, SQL Express, SQL

0

More articles:


All Articles