Modifying the User Account for a SQL Instance

You can change the account that the software uses to perform backup and restore operations to the local system account or to a specific account. For information about the required permissions, see User Account Configuration for the SQL Server Solution.

Procedure

  1. From the navigation pane, go to Protect > Databases.

    The Overview page appears.

  2. On the Instances page, click the SQL Server instance that you want to modify.

    The instance page appears.

  3. In the General section, beside SQL server authentication, click the Edit button edit button outline grey/gray pencil.

    The Edit SQL server instance dialog box appears.

  4. Move the Override higher levels settings toggle key to the right.

  5. Select the account to use.

    • To use the system account, select Use local system account.

    • To use a specific account, select Impersonate user, and then from the Credentials list, select the saved credential.

  6. Click Update.

Results

The software uses the updated credentials for the next backup operation or restore operation.

For a video about user permissions, see How to configure user permissions for the SQL agent.

Loading...