Categories
Who's Online
20 visitors online now
3 guests, 17 bots, 0 members
Support my Sponsor

Posts Tagged ‘access’

Access SQL server database of any version of SharePoint Standalone farm

I assume you know if we want to install SharePoint in a Workgroup environment, the only 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 incase if you want to access sharepoint databases for backup, troubleshoot, 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
    0226

  2. Once installation is completed, open SQL Studio management studio
    0230

Once We have management studio installed, you can either use below registry value or servername\sharepoint to access database. Make sure you use 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

0231
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
0232

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

 

Applies to all version of SharePoint servers

Microsoft Azure SQL VM not able to access

Issue :

When you logon to some server using Domain account, you cannot access the pre-installed software like SQL server.

 

Solution:

When the VM is created, it is created account you specify using Azure VM creation screen and then added to domain. So by default other account don’t have access to the application installed during VM creation. You have to 1st Logon to the server using Azure VM account give appropriate permission to domain account and then use it.