Forum Discussion
cannot run specific Stored Procedure or corresponding agent job (that is a sysadmin)
*granted user xp_cmdshell, then it complains about not having the proxy set.
*My customer doesn't want to configure a proxy. We have several other jobs setup the exact same way with the same user (so it appears) and they run fine.
*I am wondering if there is something corrupt or if someone has ideas of something I can try. This same user runs the agent service and there are 10 other jobs that have been running with this user without error and has the sysadmin role!.
Error--
User does not have permission to perform this action. [SQLSTATE 42000] (Error 15247) You do not have permission to run the RECONFIGURE statement. [SQLSTATE 42000] (Error 5812) SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', search for 'xp_cmdshell' in SQL Server Books Online. [SQLSTATE 42000] (Error 15281) User does not have permission to perform this action. [SQLSTATE 42000] (Error 15247) You do not have permission to run the RECONFIGURE statement. [SQLSTATE 42000] (Error 5812). The step failed.
1 Reply
*My customer doesn't want to configure a proxy.tanyaf55 , then tell your customer, that's not a good idea. Create a proxy account with as less as possible permissions; everything else is a high security risk.
other jobs setup the exact same way with the same user (so it appears)
You can't define a user for plain T-SQL job steps, then SQL Server-Agent account is used.
