October 26, 2004 at 11:58 am
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
October 26, 2004 at 12:14 pm
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
October 27, 2004 at 11:16 am
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