Video: How to test SQL Database Connections with Universal Data Link (UDL)
Issue
This method can be utilized in testing database connectivity/authentication between servers.
Product Line
Power Monitoring Expert 7.2.2
Power Monitoring Expert 8.2
Power Monitoring Expert 9.0
Power Monitoring Expert 2020
Power Monitoring Expert 2021
Power Monitoring Expert 2022
Power Monitoring Expert 2023
Power Monitoring Expert 2024
Environment
Windows OS
Windows SQL Server
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.
4) Enter the name of the SQL Server you are trying to connect to. <Servername>\<Instance>
5) Enter the user credentials being tested.
6) Select the database from the drop down list. (If there is no connection to the database server, this step will fail).
7) Click "Test Connection". If successful, you will get a message saying "Test connection succeeded".
Gepubliceerd voor: Schneider Electric Belgium
Hulp nodig?
Selecteer zelf het juiste product
Vind snel en eenvoudig de juiste producten en toebehoren voor uw toepassingen.
Offerte aanvragen
Dien uw aanvraag online in en een expert zal contact met u opnemen.
Verkooppunten
Vind eenvoudig de dichtstbijzijnde distributeur van Schneider Electric op uw locatie.
Help Center
Vind de antwoorden die u nodig heeft via bladeren door veelgestelde vragen over onderwerpen.