The SQL Tiger Team (t) has recently put out a guided walkthrough for SQL Connectivity issues.

Announcement
Walk Through

If you look at the bottom of the announcement you’ll also notice links to walkthroughs for

Troubleshooting Always On Issues
Troubleshooting connectivity issues with Microsoft Azure SQL Database

I’m loving this since I see a lot of connectivity issues. To start with you are asked to gather some prerequisite information. Including

• The exact error
• The SQL Error logs
• Application and System log information
• If it exists the application connection string

Honestly by the time you’ve collected all of that information you’re probably already going to have solved the problem. But just in case you haven’t, you move on to the checklist. The checklist is some basic troubleshooting steps. Make sure the instance is actually up and running for instance.

Now if you’ve made it through the prereqs and the checklist and you still have a problem you get to the guided walkthrough. I flipped through a few options and it seemed pretty good. Good explanations with lots of images where needed. I’m quite looking forward to trying it out for real.

Filed under: Microsoft SQL Server, Problem Resolution, SQLServerPedia Syndication Tagged: connection problems, microsoft sql server, problem resolution