SQLServer Agent Missing
Posted on 2004-03-24
OS -> Windows Server 2000
DB -> SQL Server 2000
Recently installed a service pack for office and it "messed" up my access to enterprise manager. Apparently, the office service pack didn't check for SQL Server. The resolution was to install the client tools from the SQL CD. It seemed to work but now realize that scheduled jobs were not running.
When I look in the event log, the following exists:
Warning: SuperSocket info (SpnRegister): Error 8344
Event Id : 19011 Source: MSSQLServer
Error: The open procedure for service "RemoteAccess" in DLL "C:\\WINNT\System32\rasctrs.dll" has taken longer than the established wait time to complete. There may be a problem with this extensible counter or the service it is collecting data from or the system may have been very busy when the call was attempted.
Error: The MSSQLServerADHelper service terminate with service-specific error 3221225572.
Would like to prevent from having to bak up all databases, uninstall and then reinstall. Any suggestions?