Sql server agent fails to start on reboot

From: Per Williamson (per_williamson_at_hotmail.com)
Date: 03/09/04 

Date: 9 Mar 2004 05:55:08 -0800

I have a problem when rebooting my Sql Server 2000. The MSSqlserver
service starts correctly but NOT the SQLAgent service. However, when
the computer is up and running, I am able to start the SQL Agent
service without problem from Enterprise Manager. After that backups
etc run as they should.

The services run under an ordinary, unprivileged user account. All
setup has been done from Enterprise manager, and as far as I can see,
the account has the necessary privileges. And, we do not experience
any trouble apart from SQL Agent not starting on reboot.

The only error message in the Event log referring to SQL Server is
"SuperSocket info: Failed to get Exclusive port use(MSAFD Tcpip
[TCP/IP]) : Error 10013. ". I really don't know if this has anything
to do with my problem.

Any idea, anyone?

Per Williamson

Relevant Pages

  • Perpetual Reboot of a Windows 2003 Server DC
    ... I’ve tried running CHKDSK /F and rebooting, but I get the same effect. ... I do see two that are set to restart the box: ... I’m primarily concerned with losing my domain, so I’ve run up a virtual machine, joined it to my domain, and now ready to make the virtual machine my BDC to preserve my domain. ...
    (microsoft.public.windows.server.general)
  • Re: memory utilization
    ... Tom ... > SQL Server will use all the ram that it thinks it can up to it's max. ... I would hold off rebooting and see if it happens ... The memory numbers make me suspect SQL Server. ...
    (microsoft.public.sqlserver.server)
  • Re: memory utilization
    ... Tom ... > SQL Server will use all the ram that it thinks it can up to it's max. ... I would hold off rebooting and see if it happens ... The memory numbers make me suspect SQL Server. ...
    (microsoft.public.sqlserver)
  • Re: access adp, sql server and recordsets
    ... Since the issue only occurs on remote SQL Server. ... A rebooting of machine after security patches may have resolved ... machine hosting Access program to test if you encounter the similar issues ... you may want to creast a new ADP and database on the SQL ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Application slowing down
    ... If rebooting causes the app to speedup you are usually running out of memory ... memory settings in SQL Server? ... > the application is running slower and slower every day and we have to ...
    (microsoft.public.sqlserver.server)