Failed to open a connection to SQL Server.

Asked By stdeip 0 points N/A Posted on - 08/30/2011

I have found a problem on using Microsoft Virtual Studio. It has failed to open a connection to SQL Server. The error message is given below:

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)

The image of error message is here:

How can the problem be solved?

Thank you.

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

• Answer Accepted: Yes
• Question Category: Photos / Graphics Soft.

Best Answer by HarvBoyd

Go To Solution

Answered By Bettythatcher 0 points N/A #85219

Failed to open a connection to SQL Server.

You must make sure that some things are all right before connecting:

1. Check your database settings so that it can accept remote connections.
2. Create an exception on the firewall for the sql server.
3. Also for SQL browser, you need to create an exception.
4. Make sure that your instance name is in your connection strings.

Then, check for some issues on the Visual studio front, and try resolving all these issues and then restart all the applications. The, you could easily create a connection.

Cheers.

About Bettythatcher

Questions
0

Answers
10

Best Answers
6

• Vote Up 0 Vote Down

• Posted on - 08/30/2011
• Question Category: Photos / Graphics Soft.

Best Answer

Best Answer

Answered By HarvBoyd 0 points N/A #85220

Failed to open a connection to SQL Server.

• Regular readers of this blog are aware that I have written about it many times before, and whenever he spoke of a new issue related to it. A few days ago, I had to rebuild my local home network. I installed a local network with wireless router connected to my four computers, two mobile devices, a printer and a VoIP solution. Also formatted my main computer and the server clean install SQL Server 2008 on it. Yesterday, however, I was sitting in my backyard trying to connect SQL Server located in the Ministry of Interior and suddenly I came across the following error. Finding the solution was the most frustrating, as it consumes my precious 10 minutes.
• I finally found a solution to an error on this very blog so I was spared from hunting for a solution.
• I am sure that the number of developers who had previously confirmed that an error during installation of SQL Server 2008 or SQL Server 2005, but eventually forgot the right solution to this error. This is just a quick update. Be sure to bookmark this because you never know when this would be the solution.
• This link will give you the solution.

About HarvBoyd

Questions
0

Answers
4

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 09/02/2011
• Question Category: Photos / Graphics Soft.