Delphix Products

Expand all | Collapse all

Failed to create SMB share

Jump to Best Answer

Mauro -12-12-2016 12:41:00 PM

  • 1.  Failed to create SMB share

    Posted 12-12-2016 11:46:00 AM
     Error   Failed to create SMB share.


     i tried everything to resolve this.

    User is administrator, firewall is disable,  ISCI is working.  SMB is enabled. I can acess the server from other desktop.


    I saw at SQL Server that Backup has been done before the error and new folder was created at delphix folder.

    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1521982/RackMultipart20161212-8464-ayljys-error_smb2_inline.jpg?1481545930">


    At backups properties at SQL Server i found the location created by delphix, but if i open it i have this error. Adress point to ip.



    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1521983/RackMultipart20161212-104417-1p8lwmp-error_smb3_inline.jpg?1481546030">



    Can you help me ?


    Thanks 

    Mauro




  • 2.  RE: Failed to create SMB share
    Best Answer

    Posted 12-12-2016 11:59:00 AM
    Mauro, Is your Prod DB a part of a Windows domain? Is the server that is running the Delphix Connector part of the same domain? Did you specify using a domain account for your connector and for Delphix?


  • 3.  RE: Failed to create SMB share

    Posted 12-12-2016 12:15:00 PM
    Hi Adam

    the server is standalone, it is not in a domain. I created on virtual machine with Windows 2012 server and SQL server 2014.

    When i install delphix connector i use the administrator account for the windows server

    when i try to create dsource i use sa account of SQL Server.



    Mauro





  • 4.  RE: Failed to create SMB share

    Posted 12-12-2016 12:37:00 PM
    Is the Delphix Connector on the same server as ProdRH, or is it installed on a different server?


  • 5.  RE: Failed to create SMB share

    Posted 12-12-2016 12:41:00 PM
    It is in the same server.


  • 6.  RE: Failed to create SMB share

    Posted 12-12-2016 01:31:00 PM
    Hello,

    Mauro, have you made any changes to the environment since the initial environment discovery job was run? Did you change the owner of the SQL Server instances, grant permission to users, etc? If so, you should perform an environment refresh in Delphix again so that Delphix understands those changes.

    The first screenshot you provided shows "Failed to create SMB share on ...". If Delphix can't create the SMB share, it makes perfect sense that your manual attempt to take a backup would fail with "The network name cannot be found.".

    Also, please note that if Delphix had successfully created the SMB share, it is unshared as soon as the job completes. Delphix does not leave that share available for security purposes. So even if it had created the SMB share, I would expect your attempt to take a backup to that location to fail because Delphix removes the share.

    Can you click the informational icon from the "Failed to create SMB share on ..." message (the circle with the letter "i" in it) and provide the full error message to us? The screenshot does not give us the full error.

    Thanks,
      Neal


  • 7.  RE: Failed to create SMB share

    Posted 12-12-2016 01:46:00 PM
    I did not change user services, i choose default options. I grant some permissions trying to solve problem and i restarted both servers but the same error occured.

    full error messagem.











  • 8.  RE: Failed to create SMB share

    Posted 12-12-2016 03:15:00 PM
    Mauro, just to be clear, are you using the source server as your staging and target server too?
    Source and staging servers must use a domain account, they will not work with a local account.
    You can review requirements here: https://docs.delphix.com/display/DOCS50/SQL+Server+Support+and+Requirements.

    Regards
    Sandro


  • 9.  RE: Failed to create SMB share

    Posted 12-12-2016 03:31:00 PM
    Hi Sandro,

    I have another server to use as target.

    I will create a domain to test again.

    The stage server may be the same as source or i needs 3 sql servers ?

    thanks.

    Mauro



  • 10.  RE: Failed to create SMB share

    Posted 12-12-2016 04:30:00 PM
    In most environments, the staging server also functions as a target server. Normally, customers would not use the source server as a staging server.


  • 11.  RE: Failed to create SMB share

    Posted 05-04-2017 04:52:00 PM
    Hi All,
    I'm facing this same error.
    I have 2 windows 12 servers with MS SQL Server 12 installed on them.
    I've been able to connect them to the engine, but when I run the dSource creation it will fail with the error:
    Failed to create SMB share on "X.X.X.X".

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

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

    Command Output
        Directory: C:\Program Files\Delphix\DelphixConnector\42286c8f-cbfc-7f6a-9ae      7-c6e584940520-staging-23\TEMP      Mode                LastWriteTime     Length Name                                ----                -------------     ------ ----                                d----          5/4/2017  12:24 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\42286c8f-cbfc-7f6a-9ae7-c6e5849405  20-staging-23\SCRIPT\CreateSMBShare.ps1:23 char:12  +         die <<<<  "$($args[0])"      + CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorExcep      tion      + FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio  
       n,die

    Now all the pre-requisites has been met. The user is a domain user, it's able to log to the machines, locally has been granted Administrative rights, on the Staging/Target Server the log on as batch right has been enabled for the user.
    The engine and the Source and Target servers are on a different network but at the end they see each other without issues.
    I've ran out of ideas of what could be happening, and the solutions on the web won't help me much.

    Regards,
    Felipe A. Hernandez.


  • 12.  RE: Failed to create SMB share

    Posted 05-04-2017 04:59:00 PM
    Can you test logging into the staging server as the domain user and creating a SMB share on the staging server?


  • 13.  RE: Failed to create SMB share

    Posted 05-04-2017 05:03:00 PM
    Hi Adam,
    Yes I'm able to connect as the domain user and share any folder that I want.
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1592012/RackMultipart20170504-99554-96n9ko-sharing_inline.png?1493920939">

    Regards,
    Felipe A. Hernandez


  • 14.  RE: Failed to create SMB share

    Posted 05-04-2017 05:04:00 PM
    Ok. Just covering the basics here. Is the environment user for your source and staging server the same? Also, are the usernames entered as the domain\user or user@domain format?


  • 15.  RE: Failed to create SMB share

    Posted 05-04-2017 05:06:00 PM
    The user is the same for both environments Source and staging. And the format used for login is domain\user


  • 16.  RE: Failed to create SMB share

    Posted 05-04-2017 05:07:00 PM
    Also, can you check that the SQL instance services are running as domain accounts, and not as local accounts?


  • 17.  RE: Failed to create SMB share

    Posted 05-04-2017 05:10:00 PM
    The SQL instance is running as a Service Account (default setting when installing the server)
    ">https://d2r1vs3d9006ap.cloudfront.net/s3_images/1592017/RackMultipart20170504-108401-b3f8z7-ServiceAccount_inline.png?1493921380">


  • 18.  RE: Failed to create SMB share

    Posted 05-04-2017 05:14:00 PM
    Try changing the source MSSQL to run as the domain account. You are choosing to do Delphix Managed backups (I believe) and that creates a temporary SMB share on the staging server. The NT Service account would not have the permissions to do that. Test my theory out here, if you are able.


  • 19.  RE: Failed to create SMB share

    Posted 05-04-2017 05:32:00 PM
    Hi Adam,

    Yes I'm using Delphix to do the managed backups.

    I was able to test your theory and changed the user that is running the source Database for the domain user and I was able to create the dSource. Now this gives me a concern that if for some reason I can't change this user (security concerns, user right, etc) I won´t be able to use Delphix for my company. Could this be changed or is anything else that could be done.

    Regards,
    Felipe A. Hernandez.


  • 20.  RE: Failed to create SMB share

    Posted 05-04-2017 07:28:00 PM
    Hi Adam,

    Do you have any news on this concern?

    Regards,
    Felipe A. Hernandez.


  • 21.  RE: Failed to create SMB share

    Posted 05-05-2017 10:08:00 AM
    Felipe, I responded to this yesterday, but for some reason it did not post. Apologies for that. I have raised my assumption internally with engineering, since the docs do not describe the behavior. Right now, my basic understanding of the Delphix Managed Backups  mechanisms we employ would mean for that it would have to be a domain account. (We are directing the source MSSQL instance to create backups on a UNC path to the staging server. A local service account would not have this ability, unless it were to a world-writable share drive).