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 :)
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