Error Connect to server in " SQL Server 2008 Database Project " with Visual Studio 2010

Question

0.00/5 (No votes)

See more:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)


What do i must to do?

Posted 4-Oct-12 9:21am

AlirezaDehqani

Add a Solution

3 solutions

Solution 3

Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running

Posted 4-Oct-12 9:51am

Sandeep Mewara

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-10-04T09:30:00

Solution 1

There are so many possible things it could be, that we can't really cover them here.

Have a look here: it covers the most popular 7 reasons: http://www.sswug.org/articlesection/default.aspx?TargetID=44331[^]

But it does miss one out: "Have you installed SqlServer somewhere you can actually get at it?" - I'd check that one first, if I was you! :laugh:

Posted 4-Oct-12 9:30am

OriginalGriff

Comments

AlirezaDehqani 4-Oct-12 15:39pm

ok. but i just installed visual studio 2010

OriginalGriff 4-Oct-12 15:46pm

Installing VS2010 does not install SQL server! You need to go to the MS site and download it if you do not already have an instance you can use - the Express version is free. (If you are developing, my preference is to have a local SQL instance on my PC to prevent changes / damage going to anyone else. If you are working as a development team though, this may be impractical)

AlirezaDehqani 6-Oct-12 7:41am

ok.i just installed visual studio 2010. so What is this => All Program => Microsoft SQl Server 2008
and SQLExpress is Running status in " SQL server Configuration management "

OriginalGriff 6-Oct-12 7:45am

Start button => All Programs => Microsoft...
If you do not have SQL server installed, then it will not appear there, so ignore that one, or check ion teh machine you do have SQL server instyalled on.

AlirezaDehqani 6-Oct-12 7:58am

okay. Thank you. my database project is running now. :)

Sandeep Mewara · Accepted Answer · 2012-10-04T09:51:00

Generally, it is surface area configuration error or sql service configuration issue. Have a look at this thread for potential reasons and resolutions: Resolving A network-related or instance-specific error occurred while establishing a connection to SQL Server[^]

If needed, See steps for setting up Surface area configuration here..

Here, look at the following blog entries related to the same:
Under the default settings SQL Server does not allow remote connections[^]
It says:
I. Make sure that Remote Connections are enabled in Surface Area Configuration tool
II. Check Whether TCP/IP protocol is enabled in the SQL Server Configuration Manager
III. Make sure that SQL server Browser service is running