Sunday, November 20, 2016

Test connectivity to SQL Server without installing any tools

Recently I was working on a project where I was required to check if the connection string to sql server was valid or not.
I just wanted to have a quick check without having to install all SQL tools.

Reference:
I came across the below page which made this check super easy:
https://blogs.technet.microsoft.com/michaelgriswold/2014/01/06/the-easy-way-to-test-sql-connectivity/

Steps to Check:

1) Create a simple txt file like check.txt
2) Rename the file from check.txt to check.udl
3) Double click the udl file
4) Move to Connection tab
5) Enter your server name, username & password
6) Click on Test Connection
7) Done. A window prompt will come telling if the connection string is valid or not.

Sample Udl File:
https://github.com/csanuragjain/extra/tree/master/TestSQLServerConnectivity

Hope it helps :)

No comments:

Post a Comment