Re: SQLAGENTSERVER startup!

Because I use this server for testing, both the SQLSERVER and the
SQLQGENTSERVER is configured to start "manualy".
There is only one instance of SqlServer installed on my PC, the default
instace.


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:OH3Jf6qmGHA.4164@xxxxxxxxxxxxxxxxxxxxxxx
Misti
Does the Agent configure to start automaticaly, right?

Do you have another instance of sql server on your computer?





"Misti" <nospam@xxxxxx> wrote in message
news:OE$9W1qmGHA.2316@xxxxxxxxxxxxxxxxxxxxxxx
You asked about the BULTIN\Administrators account I think ...

This account is under Security -> Logins and is all right, it has the
"Server Administrators" SQL Server Role and hi has "public" and
"db_owner" Database Access for all databases.

I read about this KB article, but unfortunately is not my situation, what
else could be?



Thanks' for your time.


"Uri Dimant" <urid@xxxxxxxxxxx> wrote in message
news:u6eZHYqmGHA.4992@xxxxxxxxxxxxxxxxxxxxxxx
Misti
Did you delete BULTIN/Administrator Logim in SQL Server or removed it
from sysadmin server role?


"Misti" <nospam@xxxxxx> wrote in message
news:e9$pbfpmGHA.1576@xxxxxxxxxxxxxxxxxxxxxxx
SQL Server 2000 + SP4 .

Sql Server service , startup manual, Startup account : Local System
I can start the service, the client application can connect, everything
is OK.

SqlAgentServer, startup : manual, Startup account: Local System.
When I start the server Agent manually it stops immediately.
In the Application event log I have:
1. Error: "SQLServerAgent could not be started (reason: Unable to
connect to server '(local)'; SQLServerAgent cannot start)."
2. Information: "SQLServerAgent service successfully stopped."

In the ...Management->Sql Server Agent/ Display Error Log I have 2
error messages:
1. "[165] ODBC Error: 0, Cannot generate SSPI context [SQLSTATE
HY000] "
2. "[000] Unable to connect to server '(local)'; SQLServerAgent
cannot start"

If I change the Startup account to a Local Administrator the server
agent service starts without any problems.


Any ideas why don't start my service with the Local System account.











.

Relevant Pages

  • SQLAGENTSERVER startup!
    ... SqlAgentServer, startup: manual, Startup account: Local System. ... When I start the server Agent manually it stops immediately. ... In the ...Management->Sql Server Agent/ Display Error Log I have 2 error ...
    (microsoft.public.sqlserver.security)
  • Re: SQLAGENTSERVER startup!
    ... Did you delete BULTIN/Administrator Logim in SQL Server or removed it from ... SqlAgentServer, startup: manual, Startup account: Local System. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server stops responding
    ... should be deployed to a dedicated server for best usage. ... Services showed that the SQLServer and SQLServerAgent were both running but I ... In the SQLServer error logs occasionally there is the entry 'LogEvent: Failed to report the current event. ... SQL Server is terminating this process. ...
    (microsoft.public.sqlserver.server)
  • RE: BAM Service and TDDS lock error
    ... Please let me know if this doesn't resolve the issue. ... Either another TDDS is processing the same data or there is an orphaned ... session in SQL server holding TDDS lock.Timeout expired. ... SQLServer: SQLServerName, Database: BAMPrimaryImport. ...
    (microsoft.public.biztalk.general)
  • Re: sqlserver 2000 - profiler problem!
    ... Domainadministrator angemeldet und kann Profiler mit obigen Server verbinden ... Habe von jemand in Newsgroup Rat bekommen nach Sqlserver 2000 und SP3 ...
    (microsoft.public.de.sqlserver)