Login failure when execute Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login failure when execute Job

I try to setup a Job to execute a DTS Package.
As Owner i use Windows Administrator and in Step under General I use sa log in and then OK. But when i start Job i got sa login failure and when i look under Job-Step-General then it have switch to Windows login and not Sql login. Whats the problem, how can i solve it?
What are the privileges for the SQL Agent account? Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing.
]]>