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 |
|
steelkilt
Constraint Violating Yak Guru
255 Posts |
 Posted - 2002-10-18 : 14:35:04
|
| Hi. I've inherited administration of a SQL Server 7.0 machine and noticed immediately that the SQLAgent, while included in the Service Manager listing, is not present on the machine. It must have been erased by someone in the past. I received the following error when I tried to start the SQL Agent service from the Service Manager:"An error 2 (the system cannot find the file specified) occurred while performing this service operation on the SQL Server Agent service"This suggested to me that the EXE was missing, so after failing to get the EXE installed via the standard CD installation routine, I simply copied the sqlagent.exe to the BINN folder on the server.Now I can start the SQL Agent service and it does work. However, it fires up in a DOS window (no commands show up in the window -- it's blank) and I have to minimize this window to take it out of view. If I close this DOS window, the SQL Agent service stops.Any tips on how I can get the SQL Agent service properly registered? It shows up in the WIN 2K services listing as starting automatically, so things look good there, at least.thx. |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2002-10-19 : 10:24:49
|
| This sounds a bit like a registry permissions issue, however I would seriously consider rebuilding this server. There comes a point past which hacking about becomes less useful and starting from scratch is probably the easiest and best option. Make sure you have backups of all your user and system (master,msdb) databases. Then you could try a number of things.1) detach user databases and perform a registry rebuild using the registry rebuild utility (regrebld - see BOL for details)2) Uninstall and reinstall SQL7 - restore master and msdb and then reattach user databasesHTHJasper Smith |
 |
|
|
|
|
|
SqlAgent runs only in DOS window??