Jobs Failing

  • Ok.. Guys..

    time for help again...I have 3 database plans running and couple of scheduled dts packages. From last three days my all jobs are failing with an error in the error log .

    Login failed for user 'username'\'domainname'.

    My system admin recently updated the names in windows. so I deleted the old names and added the new names to sql server. I also deleted the sql server registration and registered it again.. I am still having problems.

    Please let me know where else possibly to look. It clearly is a login problem and I have fixed the logins. 

    Thanks

    taj

     


    Tajammal Butt

  • Hello,

    SQL Server usually tracks everything by user's SID (security ID). But not always, in particular cases it uses names.

    See

    Select * from syslogins

    There is a long number under SID field. So when you re-add the Windows users that were re-created by your domain admin those users are probably added with different SIDs because Windows SIDs are usually unique. You may want to go to your job or plan and change a user who is supposed to run a job, even if it is the same name. There are several places where SIDs are stored, maybe you will just re-create a job?

    Yelena

     

    Regards,Yelena Varsha

  • Don't forget to update the SQL Agent account, too.  That is what runs the jobs.  Also, there is an 'owner' entry in each job that you may want to double-check.

    So long, and thanks for all the fish,

    Russell Shilling, MCDBA, MCSA 2K3, MCSE 2K3

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply