This topic describes additional requirements for SQL Server environments that will be used as targets for validated sync. For more information, see Setting Up SQL Server Environments: An Overview.
Requirements for SQL Server Validated Sync Target Environments
Each SQL Server target environment used for validated sync must meet these requirements:
- Only standalone target environments can be used as validated sync target environments. Windows Failover Cluster target environments and SQL Server Failover Cluster instances cannot be used.
- The SQL Server instance must be the same version as the instance hosting the source database. For more information about compatibility between different versions of SQL Server, see SQL Server Operating System Compatibility Matrices.
- The owner of the SQL Server instances on the target environment that are used for the staging databases must have SMB read access to the location containing the backup images of the source databases
- If the source database is backed up with third-party backup software like LiteSpeed or Red Gate SQL Backup Pro, you must install the backup software on both the source and the validated sync environment. For backup software compatibility requirements, see Supported Operating Systems, Server Versions, and Backup Software for SQL Server.
Windows Domain User Requirements
The Windows Domain user (for example, delphix_src) that the Delphix Engine uses on a source environment must also be enabled on the target that hosts the staging databases for the source databases. This user must be a member of the Backup Operators or Administrators group on the staging environment. This user must have Log on as a batch job rights on the Staging Server so the Delphix Engine can remotely execute commands via Powershell.
Using the secpol.msc security policy editor, navigate to Local Policies > User Rights Assignment > Log on as a batch job to set this right
The Windows Domain user (for example, delphix_trgt) that the Delphix Engine uses on a validated sync environment must: