where connection string stored in sharepoint 2010 ?

Question

_{Friday, November 11, 2011 11:18 AM | 1 vote}

Hi,

in sharepoint 2010,where connection string will stored.

sekhar

All replies (6)

_{Friday, November 11, 2011 11:21 AM ✅Answered | 3 votes}

If you ever come across a need to know the connection string for your SharePoint 2010 configuration database you can locate it in the servers registry.

The key is called dsn and it is located at:

\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDb

Regards, Fadi Abdulwahab. http://sqlgoogler.blogspot.com/ Please click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

_{Friday, November 11, 2011 8:42 PM}

Hey,

Start RUN -> REGEDIT and surf to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDb

Or you can check under IIS

or you can go under web.config and than you will see it to:

In the Run Command, trype as 'InetMgr', Here go to the Default Website node and select your virtual directory.
Right click that, and see the properties where it has been mapped. Go to the folder and you cna find the Web.Config file

Hope it helped you.

Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
Microsoft Certified Personal

_{Saturday, November 19, 2011 11:46 AM}

If we want to change the connection string, is it possible?

Regard's

AKmore

_{Saturday, November 19, 2011 11:54 AM}

Yes you can change you're connectionstring under IIS7. The perform a IISRESET but there there are many web.config and machine.config files where the connectionstring are inserted. D'ont forget to change them.

Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
Microsoft Certified Personal

_{Saturday, November 19, 2011 12:31 PM}

Do I need to stop all the dependent applications?

I will be very thankful if you can list down the related .config files.

Regard's

AKmore

_{Saturday, November 19, 2011 4:04 PM}

Hi,

I can't say yo how muche you need to modify because I don't know wicht one you need to use..

Location of your web.config file is root directory of your website

for ex if u have created mytest website then web.config is created in \mytest\ directory by default.

so location of web.config is \mytest\web.config

So, if you want to change the connectionstring of you're mysite only change that one.. If you want to change other sites to, you have to perform the same steps..

More Information on: http://forums.asp.net/t/1438838.aspx/1

Microsoft Certified Technology Specialist: SharePoint 2010, Configuring
Microsoft Certified Personal