March 18, 2002 at 9:29 pm
Recently I rebooted a production server (Sql 7, NT 4). To my surprise, noone could then connect to that box. (I couldn't even get in locally via Query Analyzer). I noted that the Sql Agent was "starting" -- never running, just starting. With some trouble I killed tha Agent and re-started it manually. Then everyone could connect. Again, I rebooted the server and, once again, the Agent would hang and noone could access the box. (So I killed the Agent and started it manually and left it that way).
Is there any way to re-install only the Agent service and not the SQL Server service itself?
TIA,
Bill
March 19, 2002 at 5:05 am
First the only way I know of to reinstall Agent is to reinstall SQL (which I would make a backup of the databases beforehand). Next reinstalling may not help as I have seen this problem before on one of our servers. The problem is that when SQL Agent starts it is trying to access an object on the filesystem in most cases (usually a dll required to start). The problem comes from another application lauching at te same time and usually block Agents access to the object or the object itself may have a registry problem. I would first see if any other pieces are hanging besides Agent (even temporarly) as this may be your culprit. Also did you install anything new or change anything around the time of the problems first occurrance. Next have you run checkdsk against the hard drive (open windows explorer, right click the hard drive, properties and tools tab. Press check now, select bad sector scan but not autofix). Next, find the following DLLs and use REGSVR32 to reregister them
SQLRESLD.DLL
SQLSVC.DLL
SEMMAP.DLL
as their registry counterparts could be corrupt in some way and causing the hang. Then try (re)installing the latest service pack for SQL and NT. Finally if all else fails plan reinstall of SQL Server.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply