Here’s what more than 2,500 business decision-makers around the world say.Download the report
...with the Facility Hero app in hand! Discover how you can optimize your maintenance efforts today.Learn more
Access tailored services, 24/7 self-service and expert help. Anywhere, anytime, any project.Discover now
Everything you need to know about our IoT technology backbone.Learn more
Explore our global offerings or select your country from one of our five regions.Global
Découvrez nos offres globales ou sélectionnez votre pays dans l’une de nos cinq régions.
Testing SQL database connections during troubleshooting
Windows Operating Systems
A user need to check to application/secondary server with the database server.
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 .txt extension 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".