Re: SQLAGENTSERVER startup!

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

  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... Client computer must use STRICTLY the INTERNAL DNS server which can ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: Same question, still no answer!!!
    ... Sounds then like we are all paying for a feature set only large companies ... The "proxy server" pc is actually an older box stuffed ... Expectation #1) keep the ethernet more or less as is. ... The kids account would be ...
    (microsoft.public.windowsxp.basics)
  • Re: Re-Post - "the trust relationship between this workstation and the
    ... "the trust relationship between this workstation and the primary domain ... only problem is adding a new user account on the station. ... This would be on the DNS server 172.20.100.2 ... Attr: subschemaSubentry ...
    (microsoft.public.windows.server.active_directory)
  • Re: GPO Problem with new SBS 2003 installation
    ... I tried the suggestion of applying hotfix 885827 on the server. ... looked correct with the WMI using the Local System account. ... > Service Account in XP SP2 instead of using the Local System account. ...
    (microsoft.public.windows.server.sbs)
  • Sending email to mydomain.com
    ... server will appear as undeliverable. ... This happens because you are using the POP3 connector... ... an NDR when an account doesn't exist). ... >different from the user account names for the exchange ...
    (microsoft.public.windows.server.sbs)