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

use Google Translate

Operating Systems: 

    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: 

    You are reporting a typo in the following text:
    Simply click the "Send typo report" button to complete the report. You can also include a comment.
    CAPTCHA
    This question is for testing whether or not you are a human visitor and to prevent automated spam submissions.
    3 + 4 =
    Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.