Delphix Products

 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

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?

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

Is the Delphix Connector on the same server as ProdRH, or is it installed on a different server?

It is in the same server.

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

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.

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

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

In most environments, the staging server also functions as a target server. Normally, customers would not use the source server as a staging server.

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.

Can you test logging into the staging server as the domain user and creating a SMB share on the staging server?

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

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?

The user is the same for both environments Source and staging. And the format used for login is domain\user

Also, can you check that the SQL instance services are running as domain accounts, and not as local accounts?

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">

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.

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.

Hi Adam,

Do you have any news on this concern?

Regards,
Felipe A. Hernandez.

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).