Create Connection String Outside VS

Step 1: Open Notepad and click File-Save As-Test.Udl. Try to save the file format as UDL

Save AS

Step 2: Open the file and select SQL Server, followed by a username and a password. Once Authentication is done we have to select the database we want:

Open

Step 3: Click the Test Connection and subsequently click OK:

test Connection

Step 4: Open the file as a text file (use right click and choose open with Notepad).

textfile

Ebook Download
View all
Learn
View all