Share via

Access SQL Server database of any version of SharePoint Standalone farm

  • Article

When installing SharePoint in a Workgroup environment, the recommended Microsoft solution is to install SharePoint standalone server. Here SQL Server embedded edition is installed with SharePoint server and SharePoint databases are created on this Embedded SQL server.

 

Normally we don’t perform any task on these SQL databases but in case if you want to access SharePoint databases for backup, troubleshooting, etc, you need to install SQL Server Management Studio to achieve the same.

 

  1. Install SQL Server Management Studio. You can download the management studio from below link:

    http://www.microsoft.com/en-in/download/confirmation.aspx?id=29062

    http://itfreesupport.com/wp-content/uploads/2015/03/0226-300x119.png

  2. Once installation is completed, open SQL Server Management Studio
    http://itfreesupport.com/wp-content/uploads/2015/03/0230-300x127.png

Once Management Studio is installed, you can either use the registry value below or servername\sharepoint to access the database. Make sure you use the SharePoint farm account when you connect to SQL Server.

  1. Go to below registry path:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL10_50.SHAREPOINT\MSSQLServer\SuperSocketNetLib\Np

http://itfreesupport.com/wp-content/uploads/2015/03/0231-300x175.png
2. Use the value in key “PipeName” to connect to SharePoint database server. As discussed above you can also use servername\sharepoint to connect to SQL instance
http://itfreesupport.com/wp-content/uploads/2015/03/0232-300x205.png

Note: You need to install SQL Server Management Studio on SharePoint server. You cannot connect remotely to this SQL instance. Do not manually modify any SharePoint database, if modified, your farm\database would be unsupported

Reference : http://itfreesupport.com/2015/03/access-sql-server-database-of-any-version-of-sharepoint-standalone-farm/