Error: 40 - Could not open a connection to SQL Server


Posted in ,

I oftentimes encounter this specific error when I try to connect to my SQL server.

"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: 2)"

Possible cause would be your SQL Service isn't running.

To fix this - check the SQL service under the Services.msc if it is actively running. If not enable it. This will let you log into your local server with ease.


Comments (2)

Sport watches mostly represents the modern wrist watches, but it can also be used casio watches represent the young age for boys and girls
watches.When you first begin shopping for watches, i recommend g shock and nice casio baby g watches.Shop over thousands of styles fine watches
including many Casio watches,casio pathfinder, g shock, waveceptor.

Interesting blog you got here. I'd like to read a bit more about this topic. The only thing it would also be great to see on this blog is a few pictures of any gizmos.
John Watcerson
Cell phone jammers