XOSOFT Replication: 12.0, 12.5, 15.0
This article will explain in detail how to check if appropriate permissions are enabled in SQL 2005 to work with an HA scenario.
CA ARCserve RHA uses Windows Authentication with MS SQL Server. The account assigned to the CA ARCserve RHA engine service will need to be a member of the SysAdmin role in the MS SQL instance defined in the High Availability scenario. In a CA ARCserve RHA High Availability Scenario for MS SQL, it is strongly recommended that the user account assigned to the CA ARCserve RHA Engine service be a domain user which is a member of the Domain Admins. group. By default the Domain Admins. Group is added to the Local Administrators Group on all Domain Member Servers. In SQL, the built in\Administrators group is a member assigned the SysAmin role. Therefore as a member of the Domain Admins. Group the CA ARCserve RHA Engine is granted the privileges of the SysAdmin. role in SQL.
- If the Domain Admins Group has been removed from the Local Administrators group, then the CA XOsoft Engine service account will need to be added to the Local Administrators group manually.
- If the builtin\Administrators are not granted the SysAdmin role, then the CA ARCserve RHA Engine service will need to be added as a SQL Login and granted the SysAdmin role.
- The same membership to the Local Administrators group and SysAdmin role would apply to the SQL server in a Workgroup.
How to verify permissions in MS SQL Server:
- The first step is to open Microsoft SQL Server Management Studio
- Next expand the instance(s) you are protecting on the left hand pane
- Expand 'Security'
- Click on 'Logins'
- On the right hand pane right click on 'BUILTIN\Administrators' and go to 'properties'
- On the top left hand pane of the box that comes up click on 'Server Roles'.
- On the right hand pane that appears make sure there is a check in the 'sysadmin' box, if there isn't a check you can check this to add the appropriate permissions.
See Related Document(s): TEC438292