Configuring the services for a VMware backup that protects SQL Server
uses the Client Service and the Legacy Network Service to access the SQL Server when it performs VMware backups and restores. The logon account for the services must meet the following requirements:
You must use an account other the Local System account as the logon account. Both services must use the same logon account. To change the logon account, you must have administrator group privileges.
For VMware backups with Replication Director, the account has access to the CIFS shares on the NetApp disk array.
The account has the fixed server role "sysadmin". You can use a domain account, a member of BUILTIN\Administrators, or another account that has this role.
If you choose to truncate logs, ensure that the account that runs the Microsoft SQL Server Service has full permissions for the Legacy Network Service
tempdirectory.This directory is
C:\Users\user\AppData\Local\Temp. User is the account that runs the Legacy Network Service.
To configure the services for a VMware backup that protects SQL Server
- Log on to the Windows host with the account that has the sysadmin role and any necessary local security privileges.
- If the SQL Server host and instance use standard or mixed security, perform the following steps:
Open the MS SQL Client.
Select File > Set SQL Server connection properties.
Provide the SQL Server Userid and Password, click Apply > Close.
- In the Windows Services application, open the Client Service.
- Provide the name of the logon account and click OK.
The account must include the domain name, followed by the user account, domain_name\account. For example, recovery\netbackup.
- Open the Legacy Network Service service.
- Configure the same logon account for this service as you did for the Client Service.
- Stop and start the services.
- Configure the services for each host that you use to browse for backups and perform restores.