Troubleshooting SQL Server Connection Issues


For those of us who spend time on the SQL Server Forums, you’ll probably agree that one of the most common calls for assistance relates to troubleshooting SQL Server connections.  This is why Rick Byham’s TechNet Wiki article on “How to Troubleshoot Connecting to the SQL Server Database Engine” is a keeper.

Rick’s article covers both basic and complex connection issues and provides concise steps required to:

1. Gather Information about an Instance of SQL Server
2.
Enable Protocols
3.
Test TCP/IP Connectivity
4.
Test Local Connection
5.
Open a Port in the Firewall
6.
Test the Connection

If you haven’t already bookmarked this article, do so today Smile

UPDATE: If you’re looking for help on troubleshooting SQL Azure connection issues, have a read of this.

%d bloggers like this: