PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Setting the sysadmin privilege for Microsoft SQL hosts

To enable the integration with PowerProtect Data Manager on each Microsoft SQL host, the NT AUTHORITY\SYSTEM account on each host requires the sysadmin privilege.

About this task

Before you register any SQL host with PowerProtect Data Manager, complete the following steps on each SQL host to set the required sysadmin privilege.

Steps

  1. Log in to each SQL instance, open the SQL Server Management Studio (SSMS), and select View > Object Explorer.
  2. In the Object Explorer, expand Security and then expand Logins.
  3. Right-click NT AUTHORITY\SYSTEM, and then select Properties.
  4. In the Login properties window, select Server Roles.
  5. Select sysadmin under Server roles.
  6. Click OK.
    The Login properties window closes.
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\