Delphix Products

 View Only
  • 1.  SMB share

    Posted 11-01-2021 01:24:00 PM
    Edited by André Rodrigues de Melo Júnior 11-01-2021 01:33:05 PM

    Hello team,

    I'm trying to take a snapshot of my MSQSL d'source, but I can't create an SMB connection. I've already given all share permissions on the MSSQL folder in source.

    Error
    Failed to create SMB share.

    Error Code
    exception.db.mssqlstagingdb.create.smbshare.failed

    Suggested Action
    Make sure that user "AWSSQLSERVER\delphix target" has permissions to create an SMB share.


    d---- 11/1/2021 3:09 PM dlpx_TEMP
    No mapping between account names and security IDs was done.

    die : Error: ERROR_SET_ACL_FAILED
    At C:\Program Files\Delphix\DelphixConnector\499121ec-d4ee-d022-1e90-8c8a229eb980-staging-140\SCRIPT\CreateSMBShare.ps1:26 char:12
    + die <<<< "$($args[0])"
    + CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorException
    + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,die


    ------------------------------
    André Rodrigues de Melo Júnior
    Community Member
    TGV Tecnologia Ltda.
    ------------------------------


  • 2.  RE: SMB share
    Best Answer

    Posted 11-01-2021 01:54:00 PM
    Hello,

    That error indicates that the user "AWSSQLSERVER\delphix target" does not have "Administrator" permission on the Windows staging/target host. When linking a new dSource if you choose the option "Delphix will take a copy-only full backup of your source database", Delphix will try to create a temporary SMB share on the Windows staging host. It will fail if it does not have "Administrator" permission.

    https://docs.delphix.com/docs/datasets/sql-server-environments-and-data-sources/quick-start-guide-for-sql-server-microsoft-sql-server-on-windows#QuickStartGuideforSQLServer(MicrosoftSQLServeronWindows)-TargetWindowsUserRequirements

    The Delphix Engine needs a Windows domain user - for example, MYDOMAIN\delphix_os - to be specified when adding Target environments to the Delphix Engine. This user must have the following permissions:

    Target User Requirement Explanation
    Be a member of the Windows "Local Administrators" group on the Target Host
    We require this permission for mounting iSCSI LUNs presented by the Delphix Engine to the staging and target hosts. Microsoft utilities used by the Delphix Engine, such as diskpart, require membership of this group.
    Have the "Log on as batch" privilege on the Target Host
    We require this permission for remote PowerShell execution. This privilege can be assigned through the Local Security Policy (Local Policies → User Rights Assignment → Log on as batch job).
    Be able to login to each SQL Server instance that the Delphix Engine will communicate with These requirements are described in the Target Database Login Requirements section below.
    Delphix Connector software is installed and running See Installing the Delphix Connector Service on the Target Database Servers for instructions on installing the Delphix Connector.
    If you feel that you have correctly configured the user with "Administrator" permission, please open a new technical support case and upload a support bundle to our upload site ( https://upload.delphix.com ).

    Thanks,
      Neal

    ------------------------------
    Neal Stack
    Senior Principal Technical Support Engineer
    Delphix
    ------------------------------