How to test Remote SQL Connection

So much product rely on SQL Databases.For example , if I’m a IT Pro who is responsible for System Center Configuration Manager, I need to know at least basic configuration of SQL Server.

One of the common problem about SQL procedures is Remote Connectivity.If your SQL Server database is central on your organization , for each product you must specify remote SQL Server address, but some connectivity problems can occur.

But there is very very simple method to test remote SQL Server connectivity from any workstation.Follow me;

– Just create a txt file on your desktop and name it whatever you want.

– Change txt extension to UDL.

– Simple click this file.

 image

As you see, you can test for remote SQL connection on any workstation without installing another components or tools.

Leave a Reply

Your email address will not be published. Required fields are marked *

5 + 5 =