How to create udl file for sql server

In this article. Select a server name from the drop-down list, or type the location of the server where the database you want to access is located. Selecting the database on the server is a separate action. Update the list by clicking "Refresh". You can select the following authentication options from this drop-down list: Windows Authentication: Authentication to SQL Server using the currently logged-in user's Windows account credentials.

User name should be set to the application client ID. Password should be set to the application client secret. When checked, allows the password to be saved with the connection string. Whether the password is included in the connection string depends on the functionality of the calling application. NOTE: If saved, the password is returned and saved unmasked and unencrypted.

On the Connection tab, fill out the connection properties according to the server, authentication type, and database name that you need. This is typically something you would already know, but if you do not, you may have to contact the database administrator or go look at the database connection properties yourself.

Click Test Connection. Hopefully it will succeed. If not, check the credentials, authentication type, and any firewalls How to: Configure a Windows Firewall for Database Engine Access between servers. Click OK. Open the url file and inside you will find the connection string. Remove Provider portion of the string. Test First, create a UDL file just like before and open it with a text editor. Like this: Like Loading Leave a Reply Cancel reply Enter your comment here Fill in your details below or click an icon to log in:.

Email required Address never made public. Name required. Follow me via Email Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3, other followers. Follow me on Twitter sqlstudent Blog at WordPress. Follow Following. SQL Studies Join 3, other followers. Sign me up. Already have a WordPress. Log in now. Loading Comments