Question
Which environment and permission requirements are necessary for the ECX CDM SQL Server solution?
Answer
Note the following Microsoft environmental requirements:
- Windows Remote Shell (WinRM) must be enabled
- The user identity must be specified in the username@FQDN format. The username must be able to authenticate using the registered password to obtain a ticket-granting ticket (TGT) from the key distribution center (KDC) on the domain specified by the fully qualified domain name.
- On the SQL server, the Windows user must have local administrator rights.
- For SQL AlwaysON, the user must have permissions to access cluster resources.
- The SQL user must enable the public and sysadmin SQL permissions.
- The user identity must have sufficient rights to install and start the ECX Tools Service on the virtual machine node. This includes "log on as a service" rights.
- The clock skew between the Domain Controller and the ECX appliance should not be more than 5 minutes
- The fully qualified domain name must be resolvable and route-able from the ECX appliance
- The virtual machine node DNS name must be resolvable and route-able from the ECX appliance
- The VMGuest version must be current
- VMware Tools must be installed on the virtual machine node
- The virtual machine must use SCSI disks only
- The virtual machine must not use dynamic disks
UUID must be enabled to perform Microsoft SQL-based Copy Data functions. To enable, power off the guest machine through the vSphere client, then select the guest and click Edit Settings. Select Options, then General under the Advanced section. Select Configuration Parameters..., then find the disk.EnableUUID parameter. If set to FALSE, change the value to TRUE. If the parameter is not available, add it by clicking Add Row, set the value to TRUE, then power on the guest.