The “UDL Test” is a quick, easy, and flexible way to test connectivity to Microsoft SQL Server using a variety of installed providers/drivers using either Windows or SQL Authentication.
To get started, simply create a new text file on your desktop and give it a name:
![](https://databasemath.com/wp-content/uploads/2021/06/image-1.png)
Change the file extension to udl:
![](https://databasemath.com/wp-content/uploads/2021/06/image-2.png)
You will get this warning:
![](https://databasemath.com/wp-content/uploads/2021/06/image-3.png)
Click Yes.
The icon should change:
![](https://databasemath.com/wp-content/uploads/2021/06/image-4.png)
Now just double click to launch:
![](https://databasemath.com/wp-content/uploads/2021/06/image-5.png)
By default the Microsoft OLEDB Provider for SQL Server is specified but you can change the provider you want to use under the Provider tab:
![](https://databasemath.com/wp-content/uploads/2021/06/image-7.png)
Under the Connection tab, specify the server name and credentials you want to use to connect to either a local or remote SQL Server instance:
NOTE: If you select "Windows NT Integrated security" the User name and password fields are greyed out. This is because the connection will use a token from the Windows account you are currently signed in with.
![](https://databasemath.com/wp-content/uploads/2021/06/image-10.png)
Lastly, click Test Connection and you should see either a “Test connection succeeded.” or “Test connection failed” pop-up:
![](https://databasemath.com/wp-content/uploads/2021/06/image-11.png)
NOTE: If you click the drop down for "Select the database on the server" this instantly tries to form a connection to master in order to return a list of available databases.