patternsqlMinor
Find which account SQL Server service is running BACKUP under
Viewed 0 times
serversqlaccountunderservicerunningfindwhichbackup
Problem
Our DBA is out and I'm trying to back up our (remote) dev database to a UNC path. I'm running the back up operation while logged into Management Studio as a particular Windows domain account (e.g.
When I attempt to execute the following as
I receive the error
Which seems to indicate that whatever account SQL Server is using to run the backup command does not have rights to that UNC path.
I do not have a way to RDP to the dev database server and find out which account SQL Server is using to execute the backup command above. Is there a way to find this out from Management Studio using e.g. a dynamic management view?
CORP\myUser). I've checked that this domain account has FULL CONTROL rights the UNC path \\nameOfMachine\backup\.When I attempt to execute the following as
CORP\myUserBACKUP DATABASE [DEV] TO DISK = N'\\nameOfMachine\backup\dev.bak' WITH COPY_ONLY, INIT;I receive the error
Cannot open backup device '\\nameOfMachine\backup\dev.bak'.
Operating system error 5(Access is denied.).Which seems to indicate that whatever account SQL Server is using to run the backup command does not have rights to that UNC path.
I do not have a way to RDP to the dev database server and find out which account SQL Server is using to execute the backup command above. Is there a way to find this out from Management Studio using e.g. a dynamic management view?
Solution
BACKUP will access the UNC under an impersonation context. This is a 'double-hop' situation and requires Kerberos constrained delegation to be configured.This is already answered at https://stackoverflow.com/questions/18749224/restore-database-from-a-shared-folder
Context
StackExchange Database Administrators Q#145665, answer score: 5
Revisions (0)
No revisions yet.