SQL Server Performance Forum – Threads Archive
Login failure when execute JobI 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
This posting is provided AS IS with no rights for the sake of knowledge sharing.