david_kidder: How to Test a SQL Connection from any Windows Machine

[Blog bot]

Источник: http://blogs.msdn.com/b/david_kidder...s-machine.aspx
==============

Here are some quick steps you can take to test a SQL Connection from any Windows machine:

Hit Windows Key + D to show the desktop.

Right-click on the desktop and choose to create a new text document



Rename the file to something that ends with the file extension UDL (this is the important part)



After which, it should look like this:



Double-click the file, which should open this window:



There you go, you have this window which should be familiar.  Enter the Server name, choose NT Integrated security if your server is using Windows logins or fill in the user name and password if it’s using SQL auth and optionally select a database then hit Test Connection at the bottom.




Источник: http://blogs.msdn.com/b/david_kidder...s-machine.aspx