Tip of the Day: SQL Server Set Up and a Windows User

  • 1
  • Announcement
  • Updated 4 years ago
*There must be a Windows user (for example, delphix_trgt) for the target host that can be used by the Delphix Engine. This can be a Windows domain or a local user. However, a local user account will prevent the target host from being used as a staging target. *

The Windows User need to meet these requirements:

  1. Must be a member of the local Administrators group for access to discovery operations on source hosts, and for mounting iSCSI LUNs presented by the Delphix Engine to the target host.
  2. Must have the server role sysadmin for each SQL Server instance that the Delphix Engine will communicate with.
    In SQL Server Management Studio, navigate to Security > Logins >delphix_trgt > Server Roles to set this role for the user. 
  3. Must have Log on as a batch job rights 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.
Photo of Jaclyn Schoof

Jaclyn Schoof

  • 5,332 Points 5k badge 2x thumb

Posted 5 years ago

  • 1
Photo of Giorgio Segnato

Giorgio Segnato

  • 332 Points 250 badge 2x thumb

After launching the first snapshot from a sqlserver source (VM), on Landshark 2.0, we get this error:
"DB_SYNC job for ... failed due to an error during execution:
Failed to discover and mount LUNs from the Delphix Engine through the iSCSI initiator on target host ... .
Make sure that the iSCSI initiator is running and that the user ... has privileges to perform disk management on the host."

We double-checked that:
delphix user is a domain user with local administrator privileges on both source and target,
it has sysadmin role on both SQL Server instances (source and target),
and has "Logon as Batch job" rights on target.
Delphix Connector and iSCSI initiator services are up and running on target machine.
(target machine is used as staging too)

Could you help us to solve this issue?
Photo of Jaclyn Schoof

Jaclyn Schoof

  • 5,092 Points 5k badge 2x thumb
new question

Please reference the new conversation here: DB_SYNC job failed due to an error during execution