SQL Connectivity issues: A guided walk through

Leave a comment

February 6, 2017 by Kenneth Fisher

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.

Leave a Reply

Fill in your details below or click an icon to log in:

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

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,606 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013
%d bloggers like this: