Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LOOKUP_BI
Constraint Violating Yak Guru
295 Posts |
 Posted - 2012-12-13 : 15:50:45
|
| Its been working all this while but for some reason it has stopped working for only 1 of our environment.Even executing exec master.dbo.xp_cmdshell 'dir c:\*.txt' brings following error mssgMsg 15121, Level 16, State 10, Procedure xp_cmdshell, Line 1An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'.Here is what I have confirmed so far 1) select * from sys.configurations = xp_cmdshell value is 1 (in column value, value_in_use, maximum)2) The ##xp_cmdshell_proxy_account## uses a Domain Service Account . This Service Account is part of the Local Administrator group and has the following user rights permissions•Act as part of the operating system.•replace process level token.•Log on as a batch job.3) I have restarted the instance and still no luck4) I am a sysadmin but was executing the above as a non admin user, the same user that runs this command through a job every night.5) Executing the above as a sysadmin works perfectly fine I think this is for sure a permission problem but not sure what else to check for ? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2012-12-13 : 19:59:38
|
| http://support.microsoft.com/kb/248391/en-ushttp://social.msdn.microsoft.com/forums/en-US/sqlsecurity/thread/c46323cd-2f10-4c6b-902d-7d1d1bcca6a3/ |
 |
|
|
|
|
|
exec master.dbo.xp_cmdshell