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

Popular posts from this blog

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

The server was unable to process the request due to an internal error. For more information about the error, either turn on IncludeExceptionDetailInFaults

Hi Guys,   I came across this issue  today. I was totally blank. Later i started observing the issue and realised that, this issue is caused just because of  mismatch of assembly version or any attribute  in Security token service's web.config file (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebServices\SecurityToken). Actual issue was i upgraded the assembly version and didn't do changes in web.config file of security token service This blog helped me to fix my issue http://underthehood.ironworks.com/2011/05/sharepoint-2010-an-exception-occurred-when-trying-to-issue-security-token-the-server-was-unable-to-p-1.html thanks pradeepa achar

[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...