Where is your SharePoint 2013 Database?

Microsoft SharePoint is a collaboration platform that stores many objects such as:

• Lists
• Libraries
• Content types
• Sites/Sub sites
• Site Pages
  

In SQL Server databases. They are broadly classified into namely the following two categories:

• Config Database.
• Content database.

Suppose you are on a SharePoint farm server and want to know where your SharePoint database is hosted. The task is simplied by a registry entry. To locate where the databases are present, issue the following command in Regeditor.

• Look for HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\[15.0|14.0|12.0]\Secure\ConfigDb
  
  
• And open the key “DNS” to get the connection string of the SharePoint database.
  

Happy SharePointing :-)