SQLBackup Not Authorized to Write to Share outside Domain
We narrowed the cause to write permissions to the Samba share ONLY when using Red Gate to write the backup file. Native SQL Server uses the same account for the SQL Server Agent and can write the .bak to the Samba share just fine.
EXEC master..sqbutility 999, 'RWE', '\XXXSambaSQL_nn' (unqualified share name)
Results: <SQBUTILITYRESULT>:0:Folder does not exist : \XXXSambaSQL_nn (cannot see the share, actually)
EXEC master..sqbutility 999, 'RWE', '\XXXsamba.domain.xxxxxxx.comSQL_nn' (fully qualified name)
Results: Insufficient rights to create files : Cannot create file "\XXXsamba.domain.xxxxxxx.comSQL_nnsql backup test 20150424145311405.txt". Access is denied.
Someone said this has to do with SQL Server recognizing NETBIOS and Redgate not using NETBIOS. (I'm a novice to network issues).
Redgate backup service account and SQL Server Agent account are the same. Using a SQL Agent job, native SQL can write to Samba and Redgate cannot.
So my question is what permission(s) do the Samba share and/or Redgate need in order for Redgate to write to the Samba share?
Database Administrator, IT
1OOO Fianna Way | Fort Smith, AR, 72919
Never sacrifice the best for something good.