40769: Acronis SharePoint Explorer: Enabling MS SQL sysadmin Role on Windows SBS

use Google Translate

Operating Systems: 

    Last update: 24-07-2017

    By default, MS SharePoint on Windows SBS does not have any MS SQL user with the sysadmin role.

    You need to assign the sysadmin role for proper Acronis SharePoint operation.

    Take the following steps to give any Windows user an MS SQL sysadmin role:

    1. Stop the SQL Server Service:
      • Run Command Line as Administrator
      • Type net stop MSSQL$SHAREPOINT
    2. Start SQL Server in Single User mode:
      • Type net start MSSQL$SHAREPOINT /m SQLCMD
    3. Connect to SQL Server in sqlcmd
      • Type sqlcmd –S.\MSSQL$SHAREPOINT
      • Copy and paste the following code to sqlcmd window:

        USE [master]
        GO
        CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
        GO
        EXEC master..sp_addsrvrolemember @loginame = N’BUILTIN\Administrators’, @rolename = N’sysadmin’
        GO

    4. Restart the service in Command line in normal mode:
      • net stop MSSQL$SHAREPOINT
      • net start MSSQL$SHAREPOINT

    See also:

     

     

    Tags: