diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)

Dec142010

How To Quickly Test Remote SQL Connectivity Using Any Account?

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 bring up a window to allow testing of remote connections to SQL.

Microsoft’s own Steve Rachui explains how to quickly and easily test remote SQL connectivity using any account you like:

Test remote SQL connectivity

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

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

[Source]

Share This Story, Choose Your Platform!

Get Latest News

Subscribe to Digital News Hub

Get our daily newsletter about the latest news in the industry.
First Name
Last Name
Email address
Secure and Spam free...