How to test a SQL Connection String using notepad

Posted on Updated on

1. Open Notepad and create an empty file and save it with a .UDL extension. Example. Connect.UDL

2. Go to your desktop and double-click on the file you just created and the Data Link Properties box will popup.

3. Select the Provider tab and Find the provider that you want to connect with and click Next.

4. Now from the Connection tab, select or enter your source/ server name -> then enter information to log on to server -> and select the database on the server.

5. Click Test Connection and click OK to save the file.

 

NOTE:  If you get an error with the connection testing, please make sure that the SQL Server Browser is running.  You can check this by opening SQL Server Configuration Manager on the SQL server and go to the Services menu.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s