Problems connecting to SQL Server after installation



I'm having problems -
but one basic problem is that SQL Server Agent SERVICE is having problems
logging on - it did fine when I first installed it, but the next time I
restarted the computer, boom - problems started.

I set it to start SQL Server and the Agent using the local System Account
(during setup)

But every time I try to restart the Agent - I get:
'The service did not start due to a logon failure"

SQL Server (2000) starts fine.

Any ideas?
Do I really need the SQL Server Agent Service started?


.



Relevant Pages

  • Re: How to restrict access to database to only IUSR_<machinename>
    ... > If SQL Server service didn't start, SQL Server Agent service will not be ... Open a command line window. ...
    (microsoft.public.sqlserver.security)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... >> SQL Server Agent service. ... > AFAIK the SQL Server Agent runs on Win9x with no problem..... ... > run as a service becouse Win9x does not support it, ...
    (microsoft.public.sqlserver.msde)
  • Re: Error Message: sp_replcmds
    ... Is the log reader stuck on initializing? ... stop SQL Server agent, and restart it to see if this clears the error ...
    (microsoft.public.sqlserver.replication)
  • Re: DTS Job - DLL Registration (User privileges)
    ... I set the logging on and unfortunately since it> returns a 'success' status I'm not getting any additional info in the> log files. ... This is a SQL Server id which is> not registered on the Windows side. ... How> can I find the appropriate SQL Server agent service id? ...
    (microsoft.public.sqlserver.dts)
  • Re: Can MSDE run SQL Server Agent service in Win98
    ... > SQL Server Agent service. ... AFAIK the SQL Server Agent runs on Win9x with no problem..... ... run as a service becouse Win9x does not support it, but you can start it as ...
    (microsoft.public.sqlserver.msde)

Loading