Configuring the services for SQL Server backups and restores
For SQL Server intelligent policies, uses the Client Service and the Legacy Network Service to access the SQL Server when it performs backups and restores.
Note the following requirements for the services logon account:
The account must have the SQL Server "sysadmin" role.
If you want to use Local System for the logon account, apply the SQL Server sysadmin role manually to the NT AUTHORITY\SYSTEM or the BUILTIN\Administrators group.
For VMware backups, different configuration is required for logon account for the services.
See Configuring the services for a VMware backup that protects SQL Server.
To configure the services for SQL Server backups and restores
- Log on to the Windows host with the account that has the SQL Server sysadmin role and any necessary local security privileges.
- In the Windows Services application, open the Client Service.
- Confirm that Local System account or a SQL Server administrator account is configured.
If you use the setting Use credentials that are defined locally on the client to register instances, both services must use the same logon account. If you use the setting Use these specific credentials to register instances, the services can use the same logon or separate logon accounts.
- Open the Legacy Network Service.
- Confirm that Local System account or a SQL Server administrator account is configured.
If you use the setting Use credentials that are defined locally on the client to register instances, both services must use the same logon account. If you use the setting Use these specific credentials to register instances, the services can use the same logon or separate logon accounts.
- If you selected a different logon account, restart the services.
- If you selected the option Use these specific credentials to register an instance or replica, an account other than Local System requires certain local security privileges.