We have our server and our server was running two instances of the SQL Server.I did'nt notice a minor thing that was causing me the following error
"Named Pipes Provider, error: 40 - Could not open a connection to SQL Server".
so in my case the solution was to give full name in the connection string.
Like before i was trying giving 10.x.x.98
But later i tried using 10.x.x.98\instancename and then it worked.
Bcoz what was happening SQL was SQL server was redirecting me to the default instance and that why i was having this problem.
No comments:
Post a Comment