{}

Our Brands

Impact-Company-Logo-English Black-01-177x54

Welcome to the Schneider Electric Website

Welcome to our website.
How can we help you today?
Video: Useful tool for testing SQL Database Connections

Article available in these languages: Spanish

Issue
This method can be utilized in testing database connectivity/authentication between servers.

Product Line
Windows Operating Systems

Resolution
There is a built-in Windows utility that can be used for testing SQL Database connections. This tool can be useful when testing username\passwords, as well as connections to remote database servers.



1. On the Desktop, right click and create a New Text Document. (Note: "Hide extensions for known file types" must NOT be checked in the Folder Options")
2. Change the file extension from .txt to .udl.
3) Double Click on the .udl file to bring up the Data Link Properties window.

Data Link Properties

4) Enter the name of the SQL Server you are trying to connect to. <Servername>\<Instance>

name of the SQL Server

5) Enter the user credentials being tested.

user credentials

6) Select the database from the drop down list. (If there is no connection to the database server, this step will fail).

 Select the database

7) Click "Test Connection". If successful, you will get a message saying "Test connection succeeded".
Test Connection

Schneider Electric Australia

Explore more
Range:
Articles that might be helpful Users group

Discuss this topic with experts

Visit our Community for first-hand insights from experts and peers on this topic and more.
Explore more
Range: