Sdílet prostřednictvím

Test remote SQL connectivity EASILY!

  • Článek

I learned about something very useful today and thought I’d share.

Have you ever been troubleshooting a problem with remote SQL Iproxy MP, remote DB, etc) and wanted to test to see if the local system account (or any account for that matter) could make a remote connection to SQL but you didn’t want to install the SQL tools just to make that test?  Seems there is a file type – UDL file – that you can simply create that will bring up a window to allow testing of remote connections to SQL.

Just go anywhere on your system and create an empty text file named anything but instead of txt make sure the extension is UDL.  Then, double-click on the file and up pops a SQL connectivity window to allow testing of remote SQL connections.

clip_image002

Very easy to use to test connectivity with a known user account or as local system (using PSExec).

Comments

  • Anonymous
    December 13, 2010
    And also, after you make test, you can open the file with notepad again and you will see the connection string to that SQL you were testing at

  • Anonymous
    December 13, 2010
    Wow! Nice one! I will cross post it! Thanks for sharing!

  • Anonymous
    December 14, 2010
    Very handy tip.  Thanks for this!

  • Anonymous
    December 15, 2010
    Great tip indeed! I cross posted it too microsoftplatform.blogspot.com

  • Anonymous
    December 15, 2010
    I love this. Thanks for sharing Steve

  • Anonymous
    December 15, 2010
    Great tip...could have used this a few weeks ago!

  • Anonymous
    December 17, 2010
    Super astuce !!!

  • Anonymous
    December 17, 2010
    Simple, but very useful, I think this is easiest way to do this, good tip, thank you for share.

  • Anonymous
    December 20, 2010
    Much needed one! Thanks.

  • Anonymous
    February 26, 2013
    Awesome! So easy! Great tip! Thanks!

  • Anonymous
    June 25, 2013
    Super awesome tip, saved me a lot of time:)

  • Anonymous
    November 14, 2013
    Neat one - also if you need rdp where this is disbaled on certain computers , create a text file and save it with an rdp extension (say myrdp.rdp) - double click on that.

  • Anonymous
    March 03, 2014
    For some reason, I am getting the error: filename.UDL: File cannot be opened. Ensure it is a valid Data Link file.   Just a note: I am not a SQL person so may be I am doing something incorrect here.  I am mainly trying to test if the username password for sql server I have, it works when I am testing from sql client.  I am in sql 2008 environment.

  • Anonymous
    March 03, 2014
    File is ok. I had entered a # and a comment, thinking in windows I will not be able to save blank file which I know is possible in unix/linux by touch command. thank you for very informative post for a non SQL person.

  • Anonymous
    April 15, 2014
    Thanks. That saved a day :) Came in very handy. Bookmarked this page as well :D

  • Anonymous
    June 10, 2014
    how do you specify the IP of the server????

  • Anonymous
    July 15, 2014
    WOW!!! It's Really Really Good....THX

  • Anonymous
    September 11, 2014
    Great indeed, very thanks, it helped checking the connectivity in my lan...

  • Anonymous
    June 10, 2015
    Great article, thank for sharing

  • Anonymous
    August 06, 2015
    Brilliant... thanks heaps! saved me a lot of time!

  • Anonymous
    August 12, 2015
    How about multiple SQL servers?

  • Anonymous
    August 12, 2015
    Awesome tip. Thank you!!!

  • Anonymous
    August 18, 2015
    Thanks for this tip . I had problem testing a remote connection , this helped me a lot

  • Anonymous
    September 28, 2015
    Thanks for sharing this, wonderful tip.. :)