Tuesday 17 June 2014

SharePoint 2010 Find configuration database name

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.
1Data Source=sp2010srv;Initial Catalog=SharePoint_Config_StyledPoint;Integrated Security=True;Enlist=False;Connect Timeout=15