How to Troubleshoot Connecting to the SQL Server Database Engine

Useful article by Rick Byham of Microsoft 

How to Troubleshoot Connecting to the SQL Server Database Engine – TechNet Articles – Home – TechNet Wiki.

These instructions are particularly useful when troubleshooting the “Connect to Server” error, which can be Error Number: 11001 (or 53), Severity: 20, State: 0

"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) (Microsoft SQL Server, Error: 53)" 

"(provider: TCP Provider, error: 0 - No such host is known.) 
(Microsoft SQL Server, Error: 11001)"
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: