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

Modern Workplace and Collaboration

~ by Paul B

Modern Workplace and Collaboration

Category Archives: Tips and Tricks

Testing SQL Connectivity

05 Tuesday Apr 2016

Posted by Paul B 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.

 

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...

Microsoft MVP

Follow Modern Workplace and Collaboration on WordPress.com

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

Join 674 other followers

Show your appreciation by donating

Links

  • Andrew Morpeth
  • Anthony Caragol
  • Get-CsJosh
  • Greig in Sydney
  • Guy Bachar
  • Jeff Schertz
  • Lasse Nordvik Wedø
  • LEXEL UC
  • Mark Vale
  • y0av. With a zero.

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

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
    • Modern Workplace and Collaboration
    • Join 674 other followers
    • Already have a WordPress.com account? Log in now.
    • Modern Workplace and Collaboration
    • 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: