Microsoft Visual Studio network related Error

Asked By petersullivaa 30 points N/A Posted on - 08/23/2011

I am trying to connect Visual studio to SQL server but it gives error and I can not connect with SQL server. I want to fetch data to SQL but due to this error I can not do my work please tell me how can I get rid from this error.

Microsoft Visual Studio

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)

OK

• Status: Open
• Question Views: 1311
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by andrew lame

Go To Solution

Best Answer

Best Answer

Answered By andrew lame 0 points N/A #96130

Microsoft Visual Studio network related Error

Basically this error indicates, that your software is corrupted and cannot be opened.  So the solution for you is that if you want to use this software, then you must install it again and then start working.

• Another way is that you can go to the control panel and then press Add/remove tab.
• You will find the software there;
• Select the software and then there is an option to repair
• Select repair and then install it again.

After completing your installation, hopefully you will be able to use that software, without errors but if it shows an error, then use the first method which I told you in the first paragraph.

Thanks.

About andrew lame

Questions
0

Answers
5

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 08/23/2011
• Question Category: MS SQL Server

Answered By deshow06 0 points N/A #96132

Microsoft Visual Studio network related Error

After verifying that instance name is correct, the sql service is running then this is how we allow remote connection in sql server.

On the configuration tools select Sql server configuration Manager.

Select SQL Server Network Configuration and select the Protocals for your named sql server instance then TCP/IP.

Then Double click on TCP/IP – Protocol  and make sure that Enabled is Yes. On the IP Addressess Tab Make sure that Enabled Is Yes.

Apply and the Restart the server.

Try connecting to the sql server and the problem will be solved.

About deshow06

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/07/2011
• Question Category: MS SQL Server