How to test remote Database Connection String

Simple way to check connectivity of SQL Server

Create a file with extension UDL (Universal Data Link ).

e.g. Create Text Document and rename its extension with “.UDL”

Once UDL file is available you can easily check database connection string.