Skip to main content
Sign Out

Welcome to Dell

My Account
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products
  • Manage your Dell EMC sites, products, and product-level contacts using Company Administration.
Sign In Create an Account Dell Financial Services Premier Sign In Partner Program Sign In
Contact Us

Your Dell.com Carts

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: <>()\