How to verify SQL Server connection details

This is something that I always forget how to do, until that day when I really need it, so I thought I would create a short video to remind myself how to do it.

Basically, when you need to test a connection to a SQL Server instance, create a new text file (doesn't matter what it is called) and change the extension to be "udl". With that done, double click on the file, and it should open up a Data Link Properties window. In this window, provide the SQL Server connection details that you are trying to verify:

- server/instance name
- Windows Authentication/SQL Server Authentication details
- Database name
- etc

Once you have provided all the details, simply click the Test Connection button, and things will either work, or they won't. With this information, you can then populate the configuration file that you are trying to fill in, or perform the installation of the application that needs the information, or whatever it is, knowing that the details you have provided are correct.

This trick has saved me a number of times, and I hope that it helps you as well.

[GabrielInnes-du]

Google search brought me here, great tool to have, thank you

[sonercelix]

Great. Learning this made me happy. Thank you.

[rajatbarik]

Thanks, it saved a good amount of my time.

[mr.venexyt]

Hello, I have i issue in visual studio 2013 ..when I create one blank solution create asp form and then I right click app data folder and click add then click add new item then occur error-56

[christianhelberg]

this is awesome, thanks for sharing. Saves time