Friday 5 December 2014

How to find sql connection string

Create a .txt file in SQL server.Ex: a.txt
Change .txt to .udl. Ex: a.udl
Double click on a.udl
It will open a window.
Enter SQL server name
Select authontication type.
Select Database
Click Test connection

Now right click on a.udl
Click on Open With
Select notepad
Now you will get sql connection string