Re: "Access denied" with xp_cmdshell (!)
- From: "Laurentiu Cristofor [MSFT]" <laur@xxxxxxxxxx>
- Date: Wed, 23 Aug 2006 16:32:10 -0700
If you recently made the domain account an administrator, you may need to
restart Sql Server for those permissions to take effect. A change of
permissions for an account won't affect processes already running as that
account.
Thanks
--
Laurentiu Cristofor [MSFT]
Software Design Engineer
SQL Server Engine
http://blogs.msdn.com/lcris/
This posting is provided "AS IS" with no warranties, and confers no rights.
"Vycka" <vyciunas@xxxxxx> wrote in message
news:ejaW$gsxGHA.2168@xxxxxxxxxxxxxxxxxxxxxxx
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
.
- Follow-Ups:
- Re: "Access denied" with xp_cmdshell (!)
- From: Vycka
- Re: "Access denied" with xp_cmdshell (!)
- References:
- "Access denied" with xp_cmdshell (!)
- From: Vycka
- "Access denied" with xp_cmdshell (!)
- Prev by Date: Re: SQL 2000 Windows Authentication - Same User Multiple Groups
- Next by Date: Re: Cannot generate SSPI Context
- Previous by thread: "Access denied" with xp_cmdshell (!)
- Next by thread: Re: "Access denied" with xp_cmdshell (!)
- Index(es):
Relevant Pages
|
