If you are receiving the following error related to connection to SQL Server, this blog is for you.
TITLE: Connect to Server
——————————
Cannot connect to Database Server.
——————————
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1326)
I suggest that you read previous article first as that describes how to fix the problem and has worked in many cases.
SQL SERVER – Fix : Error : 40 – could not open a connection to SQL server
Now if SQL Server can be connected perfectly from local system, but cannot be connected from a remote system, in that case firewall on the server where SQL Server is installed can be issued.
Follow instructions of this article to fix the issue.
Go to control panel >> Firewall Settings >> Add SQL Server’s Port to Exception List.
Now try to connect to SQL Server again. It will allow you to connect to the server successfully. Please leave a comment with your experience.
Reference: Pinal Dave (https://blog.sqlauthority.com)
141 Comments. Leave new
OMG… having tried all of the above I finally found MY problem.. it was because I had NOT SET A CONNECTION STRING in my Data Source. I did not think it was necessary as I was logging using a SQL Login and I assumed it would be intelligent enough to figure it out… hmmm not so. Test Connection showed it was OK without the connection string but when I tried to create the report it failed with Error: 40 – Could not open a connection to SQL Server
Thanks for sharing that Jon.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 1327)
Can you help me, please?
It’s worked for me, thankyou
thanx its worked with me
Thanks faris.
Go to control panel >> Firewall Settings >> Add SQL Server’s Port to Exception List. And then try to reconnect to SQL Server again. It will allow you to connect to the server successfully.
we using TCP static port instead of default port no,we are unable to connect SQL instances ,
I have added port in firewall,still we are facing the issue.