Re: SQL 2000 Server Agent fails on Windows 2003 Installation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Steve Thompson (SteveThompson_at_nomail.please)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 14:29:36 -0500

"Joe" <anonymous@discussions.microsoft.com> wrote in message
news:11f801c40863$50716610$3a01280a@phx.gbl...
> We are having trouble with the SQL 2000 Server Agent on a
> Windows 2003 server.
>
> Upon startup the following error message occurs:
>
> SQLServerAgent could not be started (reason: Unable to
> connect to server '(local)'; SQLServerAgent cannot start).
>
> Event ID 103.
>
> SP3a has been applied.
>
> How can we fix this ?

Are you using an account for the SQLServerAgent service? If so, be sure
that:
1) that account has SQL Server login access and appropriate database access
2) that you've keyed the account name/password correctly.

Have you tried starting it with 'local system' setting to see if the service
will start?

Steve

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... issues, such as a server that might have IIS running on the same machine, ... applicable to SQL 2000 environment, ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • RE: MP Install issue
    ... Where in the installation are you talking about specifying the account rather ... > MPDB ERROR - CONNECTION PARAMETERS ... > SQL Server Name: servername ... > with a trusted SQL Server connection. ...
    (microsoft.public.sms.setup)
  • Re: SQL Express Fails with Hardware Error
    ... The LocalSystem account is a built-in account, ... which the SQL Service runs. ... MCSE, CCEA, Microsoft MVP - Terminal Server ... Minimum Hardware Requirement (Warning) ...
    (microsoft.public.sqlserver.setup)
  • Re: SCCM with a remote SQL instance problems (IT IS NOT A WARNING)
    ... PreReq check is not a WARNING it is a FAILURE. ... account the run the SQL Server Service on the server, Domain Memberships, AD ...
    (microsoft.public.sms.installer)
  • Re: Distributed Query - Linked Servers?
    ... In the case of SQL style accounts, it doesn't seem very secure to me, because the password will be transmitted over the network. ... it should also be able to work by setting up a credential and proxy account on Server1. ... In this case it could work with NTLM authentication. ... we just need to verify that the 2 sql server instances are under sql server and windows authentication mode and the sql account you use has the permission on the 2 sql server instances. ...
    (microsoft.public.sqlserver.server)