• Home
  • My Tools
  • Visio Stencils
  • Online Tools
  • PS Scripts
  • PS One Liners
  • Downloads
  • Product Review
  • About

Smarter Together

~ by I.M.H.O.

Smarter Together

Tag Archives: Testing Connectivity to SQL

Testing SQL Connectivity

05 Tuesday Apr 2016

Posted by Paul Bloem in Test, Tips & Tricks, Tips and Tricks, Uncategorized

≈ Leave a comment

Tags

Testing Connectivity to SQL

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

step 1
step 2
step 3

 

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.

 

Advertisement

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)
  • Click to share on Reddit (Opens in new window)
  • Click to share on Pocket (Opens in new window)
  • Click to share on Pinterest (Opens in new window)
  • Click to share on Tumblr (Opens in new window)
  • Click to share on Skype (Opens in new window)
  • Click to email a link to a friend (Opens in new window)
  • Click to print (Opens in new window)

Like this:

Like Loading...

IMHO YouTube Channel

Follow Smarter Together on WordPress.com

Enter your email address to subscribe and receive notifications of new posts.

Join 674 other subscribers

Show your appreciation by donating

Archives

Category

ABS ABServer ADContacts Address Book AddressBook AddressBook Service Communicator contacts CX500 Devices DHCP DNS Edge Server Error Codes event id Exchange UM 2010 GAL Install Guide Lync 2013 Tools Lync Edge Lync Tools Microsoft Teams Monitoring Polycom Powershell Scripts Product Review QOS Quick Reference Guide Reskit RGS RTC Database SIP SIP Options Skype for Business Skype for Business Monitoring Skype for Business Tools SQL Teams TMG Tool Tools Troubleshoot Edge UC Sorted Tools UM Uncategorized Unified Messaging visio Visio Stencil voicemail

Create a free website or blog at WordPress.com.

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Smarter Together
    • Join 63 other followers
    • Already have a WordPress.com account? Log in now.
    • Smarter Together
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...
 

    %d bloggers like this: