Sharepoint Insight by Namwar Rizvi

Sharepoint Tips, Tricks and inside knowledge from real world experience by Namwar Rizvi

Registry setting for Sharepoint Configuration Database connection string

Posted by namwar on July 16, 2008


Ever wondered where does Sharepoint saves its configuration database connection information? Sharepoint 2007 saves its connection string for configuration database in registry and you can change it easily if you have moved your configuration database from one server to another. Following is the registry path

My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDb

and our required key is dsn

Advertisements

6 Responses to “Registry setting for Sharepoint Configuration Database connection string”

  1. Dan Usher said

    I think you mean that it’s stored in:

    My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\12.0\Secure\ConfigDB

  2. namwar said

    You are right Dan. Thanks for spotting the mistake.

  3. Habeeb said

    Thanks… Rizvi… It helped me a lot.

  4. Raja said

    Thanks… Namwar… It helped me in Migrating the configuration database without requiring to run the Sharepoint Config wizard

  5. Neil Santucci said

    Hi Namwar,
    hoping that you could give some guidance on this.

    Our live database enviroment is DBA controlled so the SharePoint databases cannot be created there. I have installed SharePoint, the databases are on a development server and now need to be moved to the live server. I used the stsadm command, as per this article http://technet.microsoft.com/en-us/library/cc512725.aspx, and the registry entry for the config database has changed but SharePoint is still using the development database server. Have I missed something?
    thanks
    Neil

  6. Neil Santucci said

    I should add that this is a SharePoint 2010 setup

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: