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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-06-17 : 19:38:48
|
Roshan writes "Dear Sir/Madam,
I am a Sri Lankan who uses SQL server version 7 with SP1. All this time the SQL server was working fine. Yesterday the SQLServerAgent service has stopped. The other services are working fine (MSDTC, Microsoft Search, MSSQL Server). But SQLServerAgent is not starting. When you observe the Event Log I found this error.
Event ID: 103
Source: SQLServerAgent
Error: SQLServerAgent could not be started. (reason: Unable to connect to server; SQLServerAgent cannot start.)
Could you please help me to sort this out.
Regards,
Roshan Perera.
Systems Administrator
SRI LANKA." |
|
|
rzk5f5
Starting Member
1 Post |
Posted - 2009-03-11 : 16:24:42
|
How can I do a consistency check if I can't open Enterprise manager. [quote]Originally posted by RickD
I would do a consistency check on your master DB, this has probably got a minor error. Same thing happened to me last week. If you have errors which can't be fixed you will have to rebuild your master DB. [/quote] |
 |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2009-03-12 : 05:38:08
|
| Sorry, but why pick up a post that is nearly 8 years old and nothing in it says about not being able to open EM?!? If you have a new question, please post it as a new question.To answer your question though, you can't, but you can rebuild the master database from the command line, you need to hope you have backups of your system DB's if you do this.http://msdn.microsoft.com/en-us/library/aa197950(SQL.80).aspx |
|
|
|
|
|
|
SQLServerAgent Could not be started