Testing SQL Connectivity


Just about every deployment has an SQL shenanigan that slows me down. Usually I will install SQL Management Studio simply to prove that I am able to connect to SQL.

That’s a BIG hammer..

I am aware that it can be done from command line, but SQL gives me the jitters on the best of days. So just recently I came across a neat little trick.

In layman’s terms you are essentially performing a Data Link (UDL – Universal Data Link) test to check connectivity from a Windows server to a SQL server instance and database.

Here is how it works..

First..

Creating the UDL File

Create a new txt document and rename it so that the file extension is .udl

TIP You will need to clear the “Hide file extensions for known file types” check box to rename the .txt to .udl

 

You are now ready to test..

Testing Connectivity

Step 1

Launch the .udl file. In my case I called it SQL Connectivity Test.udl. You should see the following GUI

step 7

Provide the server name (if you click on the drop down arrow you should see a list of all the servers found)

TIP Under the provider tab you can select other database servers.The server name drop down box is populated using the SQL Browser service. When you have multiple pools its likely that you will only see the local pool server names. You should still be able to connect. If not, you may need to add a firewall rule to allow remote SQL Browser connections in the destination server in question.

Step 2

Provide the account details for accessing the SQL server. In my case I was logged in as the user with permissions. You can either use the account you have logged in as by selecting the “Use Windows NT Integrated security” radio button, or specify different credentials by selecting the “Use a specific user name and password” radio button.

credsStep 3

Select the database to connect to, once again you should see the databases available if you click on the drop down arrow. Of course you wont get to this step if your authentication doesn’t pass or the server name is invalid.

Step 10

 

Step 4

Click Test Connection

step 9

Any errors you receive should be sufficient to forward to the SQL admins for resolution.

 

Advertisements

About Paul B

My name is Paul Bloem and I am employed at Lexel Systems in New Zealand as a Principal Consultant for Unified Communications. I have been working on enterprise voice solutions for over 20 years. My first 10 years were spent working for a Telco in South Africa (Telcom SA). This is where all the groundwork happened as I was exposed to just about every aspect of telecommunication you could imagine. I develop an interest in PBX technologies and eventually became the go-to guy. Next, I had a 10 year run at Siemens South Africa, most of my time there was as a Technical Trainer. During this time VoIP hit the world stage, I had the privilege of introducing VoIP both as H.323 and later SIP across the Siemens HiPath 4000 solution stack. In 2008 I immigrated to New Zealand with my newly attained MCSE, I was ready to go where no PBX Techie had gone before. I was employed to explore OCS 2007 and that was pretty much the beginning of the end for me. I have been working on OCS and Lync ever since. My current role focuses exclusively on Lync and associated technologies.. That includes pre-sales, consulting, architecture and design, training and support. I even get to play in the development space from time to time - focus on play ;-) I was nominated as a Microsoft VTSP for Lync early in 2013 and also awarded Microsoft's MVP award for Lync in 2014.
This entry was posted in Test, Tips & Tricks, Tips and Tricks, Uncategorized and tagged . Bookmark the permalink.

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