PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

Creating a proxy for the CmdExec subsystem

The SQL Server Agent uses proxies, which are objects that enable the SQL Server Agent to access stored credentials for Windows users, to define the security context for job steps.

1. Open SSMS, and then select View > Object Explorer.
2. Specify user credentials:
   1. In the Object Explorer, expand Security, right-click Credentials, and then select Properties.
   2. On the Credential Properties - EMC page, specify the following fields, and then click OK:
      • Credential name: Type a name for the credential.
      • Identity: Type the administrator username.
      • Password: Type the password for the user that you specified in the Identity field.
      • Confirm password: Retype the password that you specified in the Password field.
3. Create a proxy:
   1. In the Object Explorer, expand SQL Server Agent, and then expand Proxies.
   2. Right-click Proxies, and then select New proxy.
   3. On the ‘EMC’ Proxy Account Properties page, specify the following fields, and then click OK:
      • Proxy name: Type a name for the proxy.
      • Credential name: Type the credential name that you specified in step 2b.
      • Active to the following subsystems: Under this field, select Operating system (CmdExec).
        NOTE:When you create a job step, you must select this proxy from the Run as list on the Job Step Properties page.