Skip to main content
  • 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

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

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.

About this task

When you run a job step that is configured to use a proxy, the SQL Server Agent uses the credentials that are defined in the proxy, and then uses the corresponding security context to run the job step.

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.

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