How to get the SQL Server connection string

2. First step: Create a Wizard File

   Create a TXT file on the desktop and change the file suffix to ". udl".

4. Step Two: Select the Provider tab page

   Double-click the newly created. udl file, enter the Provider tab, and select Microsoft OLE DB Provider for SQL Server.

6. Step three: Set up "Connect"

   After the second step, select the "Next" button and go to "Connect" tab, in "1. Select or enter the server name (E)" Enter ".", then select "2. Enter information for the login server", and in "3rd" select "Select Database on Server".

8. Fourth step: Test If the connection is successful

   On the Connect tab, click the Test Connection button in the lower right corner to test if the connection is successful.

10. 5

    Fifth step: Get the connection string

    When the fourth step "test succeeded", open the ". udl" file with Notepad to get the connection string.

How to get the SQL Server connection string