Unable to run SQL job "Non-sysadmins denied..."

[web4fun]

Environment:

SQL Server 2005 with SP2 and all SP2 updates

Problem:

Unable to run SQL job that uses SSIS packages EVEN logged in as a user with 'SYSADMIN' priveleges. Encountering the following message in the Job History, "Non-Sysadmins have been denied permission to run DTS Execution steps without a proxy account. The step failed."

The curious thing is that this used to work and all of a sudden has stopped working??? We do not have a proxy account defined and never have...and the user that I'm running the job as is a SYSADMIN on the server.

Any assistance would be greatly appreciated. Thanks.

 

[mrdenny]

Is it a sysadmin on the SQL Server on in Windows?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[web4fun]

Hey MrDenny...it is both a SYSADMIN in SQL Server and a member of the local Administrators group. We're using domain logins for access. Thanks in advance for your assistance.

 

[mrdenny]

Sounds like either the account which is running the SQL Agent or the login which is the owner of the job is not a member of the sysadmin fixed server role.

That's they only way that you can get that error.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com