18 July 2013

MSSQL SERVER: Check SQL Connection Without Installing Anything

Problem
You need to check the SQL connection from a web server to a database server but don't want to install unnecessary programs (e.g. SQL Server Management Studio).

Solution

  1. Create a file called SQLConnectionCheck.udl
  2. Run it (double click or Enter)
  3. Enter the SQL connection parameters
  4. Click Test Connection

No comments:

Post a Comment