November 4, 2010 at 5:14 am
Hi All,
Below error coming during SQL Server 2008 Login
["A network related or instance specific error occurred while establishing a connection to SQL Server."]
The server was found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connection. (provider: Name Pipes provider, error: 40 Could not open a connection to SQL Sever) (Microsoft SQL Server, Error:2)
With Regards
Sanjay Thakur
November 4, 2010 at 5:24 am
We really need some more info to be helpful.
is the server running and does it exist?
November 4, 2010 at 5:47 am
Check if the SQL Server services are running.
Check you are connecting to the correct instance
Check if Remote Connections are enabled
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
November 4, 2010 at 6:48 am
If you are trying to connect to a named instance, SQL Server Browser service should be running.
If you are trying to connect from a different machine, you need to enable TCP protocol.
November 4, 2010 at 11:04 am
One more option, besides verify the TCP/IP enabled is to check the firewall and specificly port 1433
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply