Re: help plz. serveragent fails
From: Steve Thompson (stevethompson_at_nomail.please)
Date: 08/03/04
- Next message: Jim: "SQL Server 2000 maintainence plan...."
- Previous message: Keith Kratochvil: "Re: SQL Developers Edition and Windows XP"
- In reply to: steve: "help plz. serveragent fails"
- Next in thread: steve: "Re: help plz. serveragent fails"
- Reply: steve: "Re: help plz. serveragent fails"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 3 Aug 2004 09:58:48 -0400
Actually, that is not a good idea to use 'sa', typically you'd run this
service either as "Local System" (also not a good idea ;), or under a local
user or domain user account. See SQL Server security best practices with
regard to proper permissions:
Item #6
http://www.microsoft.com/sql/techinfo/administration/2000/security/securingsqlserver.asp
Steve
"steve" <anonymous@discussions.microsoft.com> wrote in message
news:9cd201c478ff$6f639f90$a601280a@phx.gbl...
> Hi,
>
> We installed SP3a as requested by our programmer as
> backups refused to schedule on MSDE2000a. All else fine.
>
> We are using SQL Eval tools, they worked fine.
> After SP3a the Serveragent refused to start using SQL
> authentication. I played with identical setup in lab and
> determined that SP3a reset PW. Using Security\Logins I
> reset PW in lab and that one started ok using SQL server
> athentication. No matter what we do on production unit,
> only WIndows authentication will work to start
> Serveragent. The error will read different things
> depending upon where one views it. Essentially it
> appears that SA account/pw is being rejected by
> Serveragent process. That same sa account and pw works on
> everthing else. I removed MSDE, folders registry entries
> etc and then reinstalled. Still fails. I've compared
> page by page to my lab setup and they match. The
> programmer has tried. We removed administrator and added
> back per one KB article. we are eunning AD if that makes a
> difference to your answer. Anyone have a clue? errors below
>
> [298] SQLServer Error: 18456, Login failed for user 'sa'.
> [SQLSTATE 28000]
>
>
>
> SQLServerAgent could not be started (reason: Unable to
> connect to server; SQLServerAgent cannot start).
- Next message: Jim: "SQL Server 2000 maintainence plan...."
- Previous message: Keith Kratochvil: "Re: SQL Developers Edition and Windows XP"
- In reply to: steve: "help plz. serveragent fails"
- Next in thread: steve: "Re: help plz. serveragent fails"
- Reply: steve: "Re: help plz. serveragent fails"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
