October 3, 2007 at 7:48 am
I have scheduled maintenace plan in one production server, the backups files to be moved to different server (Shared folder). I have tried with xp_cmdshell, it is giving Access denied. Iam using widows authentication to do this. it has sysadmin privilage and i have enabled xp_cmdshell option in surface area configuration. please help me!
October 3, 2007 at 8:14 am
what service account are your sqlserver services running under? Are they running under a domain account with the correct priv?
October 3, 2007 at 8:31 am
If the service account is running under a "domain user" account you must grant permissions to that account on the destination share.
* Noel
October 4, 2007 at 2:43 am
Yes, this acoount has sysadmin privilages
October 4, 2007 at 2:46 am
Full Permission given for shared folder to this domain user
October 4, 2007 at 6:20 am
When running xp_cmdshell, if the account you are using is a sysadmin within SQL Server, it acts on the operating system as the SQL Server service account (not necessarily the Windows account that's connecting to SQL Server, if you are using a Windows account).
That account (the SQL Server service account) must be a domain account. It also must have Write permissions both at the Share level and the file system (NTFS) level for the destination folder.
K. Brian Kelley
@kbriankelley
October 4, 2007 at 8:49 am
I have found that it is actually easier just to back up from the SQL server to a network share, since either way you are moving data over the network. Make sure that the service accounts (both the Agent and SQLServer)have access to the network share that you want to back up to. (You may only need to give the agent service account access.)
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply