Test Database connection and extract the connectionstring element

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