First step: Create a Wizard File
Create a TXT file on the desktop and change the file suffix to ". udl".
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.
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".
Or
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.
- 5
Fifth step: Get the connection string
When the fourth step "test succeeded", open the ". udl" file with Notepad to get the connection string.
Or
". Net MVC4 connectionstring Settings" Get the connection string for the SQL Server database