September 22, 2008 at 4:43 pm
I have accidentally removed the NT AUTHORITY\SYSTEM login by scripting the creation of a database and scripting logins but also asking it to include the drop commands - DOH!
Not supprisingly, I am now getting a lot of logon failure messages in my log file as I had a job set up that was scheduled to run every two minutes and wants to use this login to run. Can anyone tell me how to recreate this login and what roles I need to assign etc?
Cheers muchly,
H.
September 22, 2008 at 4:57 pm
I'm guessing you just removed it from SQL Server and not the builtin administrators group in windows. Go have a look to make sure it's still there. You could possibly just add it back to SQL Server but I don't have an instance I can currently test that one on.
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
September 22, 2008 at 5:37 pm
Making progress....
I tried creating a login called SYSTEM rather than NT AUTHORITY\SYSTEM (which was resluting in a 'nt authority\SYSTEM' is not a valid name because it contains invalid characters message), and now two new users have appeared in the login list. one called SYSTEM and one called NT AUTHORITY\SYSTEM. how strange......
I deleted the SYSTEM user and NT AUTHORITY\SYSTEM is still there and my script is now not producing errors in the log.
I am hoping all is now well, but if you can think of anything that I should be checking on (ie is there another system type user that might have been deleted by my database script that I need to re-add?), I would be most grateful.
Cheers muchly,
H.
September 22, 2008 at 5:54 pm
What account do you have SQL Server and SQL Server Agent running under?
MCITP, Database Administrator
A hodgepodge of Information Technology and Life
LinkedIn Profile
My Twitter
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply