Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
 Posted - 2003-03-08 : 15:05:53
|
| Is there a way of safely repairing this?The Sql Server is working fine. Recently I had a virus attack and since then this SQL Agent wouldn't start. it says.."could not start the SQLAgent$Gateway service on the servernameThe service did not return an error. This could be an internal Windows error or an internal service error. ifthe problem persists,....." and only OK to click.The SQL Agent error log shows two entries"[298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000] " and "[000] Unable to connect to server 'QAUASRV\GATEWAY'; SQLServerAgent cannot start"I tried resetting the password for SA and also tried resettign the service startup account info twice...no luck...anything other than reinstall is welcome..and yes, I even tried installing Service Pack 2 on it... |
|
|
scullee
Posting Yak Master
103 Posts |
Posted - 2003-03-09 : 04:49:49
|
| Are you sure you are changing the SA password for the correct Instance?Edited by - scullee on 03/09/2003 04:52:04 |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-03-10 : 02:21:48
|
quote:
Are you sure you are changing the SA password for the correct Instance?Edited by - scullee on 03/09/2003 04:52:04
I agree with scullee.check for the right sa password.secondly are u able to start the sql server? Expect the UnExpected |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-03-10 : 13:59:24
|
| Yes the SQL Server starts no problem.I did change the passwords for sa back and forth. No luck.I work with 10 instances off of my server. I checked and double checked. At first, the netlib.dll was missing. I copied it there...from another instance. It still did not work. In the net library, this does show up as existing. but if the dll was a problem the sql server per se would not run...See if you can think of something else....Thanks |
|
|
|
pareshmotiwala
Constraint Violating Yak Guru
323 Posts |
Posted - 2003-03-13 : 15:16:18
|
| I changed the password using sp_password to password.But if I change it to the old password, the sql agent does not start.The new password or any other password works...God Bless Microsoft... |
|
|
|
|
|
|
SQL Agent Wouldn't start