1. Create a notepad file.
2. Open the file and click on File menu Save as Now give the name for file and enter the extension as .udl and Save as type as All Files. Here the file name is dbTest.udl
3. The file will look as follows
4. Now double click on the dbTest.udl file. An window will get opened
5. Select the server name.. Usually ServerName\Sharepoint
6. Choose windows NT Integrated security (if) else enter the db engine password.
7. Now Select the DB name under the point number (3)
8. Now Click On Test Connection. If it shows Success message then the connection is happening and you can copy the generated connection string and make use. Open the File in notepad and you can find the connection string
Now extract the connection string as
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMP_FBA;Data Source=SERVER NAME\SHAREPOINT
Hope this may help
Pradeepa Achar
2. Open the file and click on File menu Save as Now give the name for file and enter the extension as .udl and Save as type as All Files. Here the file name is dbTest.udl
3. The file will look as follows
4. Now double click on the dbTest.udl file. An window will get opened
5. Select the server name.. Usually ServerName\Sharepoint
6. Choose windows NT Integrated security (if) else enter the db engine password.
7. Now Select the DB name under the point number (3)
8. Now Click On Test Connection. If it shows Success message then the connection is happening and you can copy the generated connection string and make use. Open the File in notepad and you can find the connection string
Now extract the connection string as
Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=TMP_FBA;Data Source=SERVER NAME\SHAREPOINT
Hope this may help
Pradeepa Achar
Comments