Skip to main content

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

Comments

Post a Comment

Popular posts from this blog

[Solution] :How to not serialize the __type property on JSON object

While working on ajax- webservice , most of the time we prefer return value from web service method should be in JSON format . If we expect a web service method to return the value as JSON object then it will display few information about the source code through the __type property. Also this property is additional load for response. We ideally need to avoid this property Have a look at the below image in which it is returning JSON object which has my custom properties along with __type property. Here i have used burp suite penetration testing tool to test the loophole in our software. Through fiddler i have got the information about request /response  and wanted to hide error message which gets generated from exception. Usually stack trace may allow hackers to  retrieve error message which  contains code related information by using which hacker can easily find the loophole to hack the function.So when  exception arises hacker should not be...
Post a Comment
Continue »

error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object

While deploying using Visual studio, we may get an error "error occurred in deployment step 'recycle iis application pool' :object reference not set to an instance of an object" Solution:  Don't get  panic ..Simply restart the visual studio with the solution which you wanted to deploy on to the site This may help some one. -cheers pradeepa achar
5 comments
Continue »
Hi Buddies,                    While doing some research i have got a   blog which has some information regarding SharePoint2007 and SharePoint 2010.Just Go through that link.You will like it as it explains from the installation of Sharepoint.
Post a Comment
Continue »