PowerProtect: How to configure PPDM to use local account on a Microsoft SQL server for backup

The following are instructions to use a local account for Microsoft SQL server databases backup:

1. Create a local Microsoft Windows user account on the host where Microsoft SQL server is installed and add user to the local Administrators group.
2. Add a user account to Microsoft SQL Server Logins, assign required roles and permissions as per documentation. 
3. Configure credentials within PowerProtect Data Manager UI to be used for taking SQL database backup.

Creating a local Microsoft Windows user account:

1. Open Computer Management.
2. Under System Tools, expand Local Users and Groups.
3. Select Users.
4. Right-click and select New User.
5. On the New User window, fill up the required details and select Create button.

Adding user to the local Administrators group:

1. Within Computer Management, select Groups. 
2. Right click Administrators group and select Add to Group.
3. Select Add button.
4. On the Select Users, Computers, Service Accounts, or Groups window, select Locations button. 
5. On the Locations window, select hostname of the host running Microsoft SQL server services and select OK button.
6. On the Select Users, Computers, Service Accounts, or Groups window, type the account name for the local user that was created in the section above and select Check Names button.
7. Verify that the correct user is selected and select OK button.

Adding a local user account to Microsoft SQL Server Logins, assign roles and permissions:

1. Start Microsoft SQL Server Management Studio and open Object Explorer.
2. Select the SQL server instance name.
3. Expand Security followed by Logins.
4. Right click on Logins and select New Login.
5. On the Login - New window under General page, next to the Login Name field select Search button.
6. On the Select User or Group window, make sure Locations is set to hostname and type username created in section above and select Check Names button.
7. Select OK button once username is validated.
8. Make sure Windows Authentication option is selected.
9. On the Server Roles page, public would be already selected, select sysadmin server role. More information about this role requirement can be found in the PowerProtect Data Manager Microsoft SQL Server User Guide under Setting the sysadmin privilege for database OS account section.
10. Select OK button.

Configure credentials within PowerProtect Data Manager UI to be used for SQL database backup:

1. Log on to PowerProtect Data Manager UI.
2. Select Infrastructure.
3. Select Asset Sources.
4. On the Asset Sources window, select the SQL tab.
5. Select host entry and select Edit Credentials.
6. Select Type as OS.
7. In the Name field, add how you want to identify credentials within PowerProtect Data Manager.
8. Next to User Name type the username of the user created in the section above. While typing username, only type username without @ sign or without \ sign. Since it is not a domain user, we do not need to use @ sign and format using \ in the syntax is not supported.
9. Select Save button.