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 |
|
khightower
Starting Member
1 Post |
 Posted - 2003-02-20 : 16:57:18
|
| I am testing SQL Server 7.0 SP4 on a W2K server, and I'm having the following problem: It's in a closed testing environment, so this might be part of the problem, but after I restore databases (master, msdb, model, etc.), I can't get the SQL Agent to start. The error I get (Event ID 103) tells me that no error was returned. Anyone experienced this before? Thanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-02-20 : 17:07:58
|
| Have you checked the account that the SQLSERVERAGENT is running under? Does the Event Viewer have any more information than what the error says? |
 |
|
|
nishithrn
Yak Posting Veteran
58 Posts |
Posted - 2003-02-24 : 01:50:33
|
Hi,U can try the following.. 1. Check whether the service account is not locked,disabled or expired.2. Try to reset the password of the servive account in the USrMgr.3. Start the SQL Agent Service with local System Account or some other domain account. bye |
|
|
|
|
|
|
SQL Agent Failure after database restore