September 19, 2011 at 3:36 pm
I have 4 new servers that I setup a proxy to run cmdshell.
I verified all 4 servers by running
EXECUTE AS login = ‘cmdshelluser’
EXEC xp_cmdshell ‘DIR C:\*.*’
and they are sucessful
It works fine on 3 of the servers where the application connects directly to the DB
We run terminal services in application mode to connect too the 4th server and the application passes the following errors:
Line1: 1526
Line2: Connectivity Error: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'
Line3: The EXECUTE permission was denied on the object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'
it works fine when I am logged in with my elevated rights. I have tried to match rights but no luck. Can anyone give me some ideas to check?
Thanks, Jim
September 19, 2011 at 4:36 pm
I'd run a trace and see what user/login is used to connect and run xp_cmdshell on that fourth server from the terminal services session.
September 19, 2011 at 4:46 pm
thanks for the reply. Can you tell me how I do that with SQL2008 on WIN2008?
Jim
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply