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 :-)
Ebook Download
View all
Learn
View all