Hi Neal:
We switched to using a domain user and how are getting this error
Run SnapSync for database "LUNDB".For dSource "LUNDB", failed to query source database backup.
Make sure the user "SMU\smu" has privilege to restore filelists/header out of backups on instance "MSSQLSERVER" running on host "10.80.238.205" and the instance owner "NT Service\MSSQLSERVER" has permissions to read the backup. Refer to Microsoft SQL Server documentation for the required privileges.
Changed database context to 'master'.
Msg 213, Level 16, State 7, Server SMU-238-205, Line 1
Column name or number of supplied values does not match table definition.
Msg 3013, Level 16, State 1, Server SMU-238-205, Line 1
RESTORE FILELIST is terminating abnormally.
Msg 50000, Level 11, State 127, Server SMU-238-205, Line 3
error_restore_filelist
die : Error: run_sqlcmd_failed
At C:\Program Files\Delphix\DelphixConnector\101b5208-7f80-9c0d-ecfe-ffe7067b8a
97-staging-39\SCRIPT\RunSqlcmdWithEncryptionKey.ps1:23 char:9
+ die "$($args[0])"
+ ~~~~~~~~~~~~~~~~~
+ CategoryInfo : NotSpecified: (:) [Write-Error], WriteErrorExcep
tion
+ FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorExceptio
n,die
This domain user has role memberships described here --
https://docs.delphix.com/display/DOCS43/Requirements+for+SQL+Server+Source+Hosts+and+Databases#Requi...What else am I missing?
Thanks