Connecting to SQL Server should be a simple task. However, there are many ways a connection may fail. Microsoft has a handful of KB articles to help, but they are not listed in one place. So, I put together this page to keep track of the support pages that Microsoft has created to troubleshoot common SQL Server connectivity errors.
Useful Links For SQL Server Connectivity Troubleshooting
Solving Connectivity errors to SQL Server
This page is great for troubleshooting basic connection issues. It provides details you need for troubleshooting, and it tells you where to find the information. With the necessary data collected you can diagnose and fix issues in a few minutes.
Troubleshooting AlwaysOn Issues
This page does more than troubleshoot connections issues for Availability Groups. It also helps with issues such as the failover to a secondary node, and how to manage the size of the transaction log for the AG databases. It’s a great first reference point for anyone that needs to quickly diagnose an issue with AGs.
Troubleshooting connectivity issues with Microsoft Azure SQL Database
This page contains the most information I have seen regarding Azure SQL Database connectivity troubleshooting. There are sections to help you understand the tools used to test connectivity.
A list of connection strings for SQL Server. You can even search by version.
Troubleshooting Azure Connectivity: Ports and Endpoints
A personal story about life, love, and why the network is always to blame. Always.
I will add links to new pages as they become available. If you know a page to include, leave a comment for me to review.
Thanks!
