Whenever a connection to SQL Server fails, it’s usually blamed on SQL Server by default. There are dozens of things between the user and SQL Server that could cause the connection to fail. The problem is proving it. How do you convince someone that “it’s not me, it’s you”? And then of course, sometimes it actually is SQL Server. This session will demonstrate how to determine the root cause of the failures and explain how to prove to others what the real issue is.

We will look at some of the most common connection issues and show how to troubleshoot them. This session will start with the basics like firewalls and SQL Server protocols and move on to some more advanced topics like mining the ring buffer connectivity data for connection issues.

Robert L. Davis was a senior database administrator and technical lead at Microsoft. He had over 11 years of experience with SQL Server, including expertise in high availability, disaster recovery, performance tuning, and data architecture. Robert was a speaker and trainer. He was also a writer for SQL Server Magazine and co-authored “Pro SQL Server 2008 Mirroring” by Apress.

Topics:
Products: DB PowerStudio