Thursday, June 5, 2014

How to find the name of your configuration database in SharePoint 2010.

This is a quick tip if you need to find the configuration database name. The alternative to the solution below would be connecting to your SQL server and looking through the names of the databases within.
1. Remote into your server in the farm where central admin is installed.
2. Open regedit [Start > Run > "regedit"]
3. Navigate to [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure\ConfigDB]
4. Open the [dsn] key.
Done! You now have your config database name.
It should look something like this.

Data Source=sp2010srv;Initial Catalog=SharePoint_Config_StyledPoint;Integrated Security=True;Enlist=False;Connect Timeout=15

No comments:

Post a Comment