"Access denied" with xp_cmdshell (!)

Hello,

I'm running this command on my SQL server and I'm getting an error 'Access
denied.'

EXEC master.dbo.xp_cmdshell 'cacls "\\PC1\Temp\3.bmp" \E \G
DOMAIN\User:R'


- My sql server service is running on a domain account and that account is
and administrator in sql server computer and in computer PC1.
- Directory "Temp" Sharing rights are "everyone - full control".
- File 3.bmp permissions are that all admins get full control.


This command works fine only when I set file permissions to "everyone - full
control".


SQL server version - MS SQL 2005 Standard edition x64

Thanks for help

Vyckla



.

Relevant Pages
Quantcast