March 9, 2005 at 1:33 pm
Today I change the sa password, after that every minutes the Event viewer is getting this message even in MS-SQL\SQLAGENT.OUT folder I am getting this error.
2005-03-09 10:03:00 - ! [382] Logon to server '(local)' failed (JobManager)
2005-03-09 10:03:01 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2005-03-09 10:03:01 - ! [382] Logon to server '(local)' failed (JobManager)
2005-03-09 10:03:02 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
2005-03-09 10:03:02 - ! [382] Logon to server '(local)' failed (JobManager)
2005-03-09 10:03:03 - ! [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000]
What to do to stop this??
Thanks
Nita
March 9, 2005 at 1:59 pm
if you are using the sa password on the registration of the server on EM right click on it, select edit registration properties and update sa password and also make sure that automatically start the service is unchecked
HTH
* Noel
March 9, 2005 at 6:27 pm
Thanks,
when I changed to old password back it started up
So I will try to Uncheck and let see if works....but what if some one forget the old pasword how to start the Agent like on this case I cannot able to start until I put my old password.
Thanks
NIta
March 10, 2005 at 8:34 am
Nita,
That setting will try to start it but because it should be started already as a service it won't do anything. The messages that you see is because it has to log in first to show the EM Server components and because the login was incorrect you got those failure messages.
hth
* Noel
March 10, 2005 at 12:10 pm
Nita,
I would guess that the SQL Server Agent is attempting to log in to the SQL Server as sa.
To verify, right-click on the SQL Server Agent in Enterprise Manager and select Properties.
You will then see a Connection tab. You'll likely have this set for "Use SQL Server Authentication" with sa as the user. Just enter your new sa password here and it should work.
Hope this helps.
-- J.Kozloski, MCDBA, MCITP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply