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

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 »

How to get the SharePoint central admin url programmaticaly via C#?

I had come across a situation where i had to get the sharepoint central admin's url.. You can follow the following snippet of the code. At the begining add the namespace  using Microsoft.SharePoint.Administration; SPAdministrationWebApplication centralAdminFarmUrl =  Microsoft.SharePoint.Administration.SPAdministrationWebApplication.Local ; String  centralAdminUrl = centralAdminFarmUrl.Sites[0].Url;  This may help someone -Cheers Pradeepa Achar
1 comment
Continue »

Programmatically read the value from web.config file

Here is a situation where you need to keep a key value pair element in the web.config file and read them during the run time. I suggest, better keep key /value pair under <appSettings> element and read it programmatically . <appSettings>   <add key=" LicenseKey " value=" 987jKouterhsk " /> </appSettings> Assume , you have added a license key as above in the web.config file. You need the license key during run time. You can access the license key class named "ConfigurationManager". write a property  called getLicenseKey and return the corresponding license key. public string GetLicenseKey {    get{   return  ConfigurationManager.AppSettings[" LicenseKey "]; } } Now the property GetLicenseKey will have the value 987jKouterhsk. Use this value as per your requirement. -Cheers Pradeepa Achar
Post a Comment
Continue »