Re: SQLAGENTSERVER startup!

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

  • Re: Compromise?
    ... Yes, if you don't provide a password on your SA account, anybody able to run ... and connect now has complete control over your SQL Server. ... Server has. ...
    (microsoft.public.sqlserver.security)
  • Re: Windows Auth to SQL Server from ATL Web Service not working...
    ... account I'm logged on as. ... SQL on a different box from my web service in an Atl Server web ... impersonation token is not passed on to the SQL Server. ... Event Category: Account Logon ...
    (microsoft.public.vc.atl)
  • Re: Discussing 3 different strategies for deleting from multiple tables
    ... I will be using SQL Server but I am riding on top of a third party ... FYI, Account contains around 20K ... >>> This results in one parameterized query followed by two more trips to ...
    (microsoft.public.data.ado)
  • RE: connection problems in secondary site and SQL server
    ... Do you have a Windows 2003 server anywhere in your environment? ... i can't add this account to this group. ... SMS Management Point encountered an error when connecting to its Database ... SMS on SQL Server My_Primary_SMS_Server. ...
    (microsoft.public.sms.admin)
  • RE: MP Install issue
    ... Will setting the SPN on the domain account fix the communication issue ... >> MPDB ERROR - CONNECTION PARAMETERS ... >> with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)