August 28, 2007 at 4:39 pm
I have user(XYZ) that is local to SQL Server(SQL ID). I made this user 'XYZ' the DTS pkg owner & applied necessary privielege based on Microsoft Website = http://support.microsoft.com/kb/890775
I followed Method 1 for "Add a SQL Server login account" & also i did Method 2 "Run a Transact-SQL script"
USE master
GO
-- Grant execute permission on xp_cmdshell to the SQL Server login account.
GRANT exec ON xp_cmdshell TO <XYZ>
GO
Still this jobs are failing & getting following error message "Non-SysAdmins have been denied permission to run CmdExec job steps. The step failed."
Any help is appreciated.
Thanking in advance
August 28, 2007 at 4:48 pm
Try this, came from http://www.webservertalk.com/archive132-2005-9-1196296.html
Under properties of SQL Server Agent there's a setting under the job system tab:
"Non-sysadmin job step proxy account" - I checked this off and users were OK.
August 28, 2007 at 5:01 pm
I am aware of this feature & moment i check that OFF it prompts another window about entering user credentials. but this one is risky & i don't want to do that for this SQL ID(USER). Thanks for the help though.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply