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.

Advertisements

About Mr. Wharty's Ramblings
Jeff holds a Master’s Degree in Systems Development (.NET Stream) and a Master’s Degree in Database Design and Management (SQL Server). Jeff is also a MCT specialising in SQL Server technologies and holds MCPD, MCITP, MCDBA and MCSD certifications.

One Response to Troubleshooting SQL Server Connection Issues

  1. Pingback: Troubleshooting SQL Azure Connection Issues « Mr. Wharty's Ramblings

Leave a Reply

Please log in using one of these methods to post your comment:

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: