Showing posts with label sql server. Show all posts
Showing posts with label sql server. Show all posts

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