Re: Changing SQL and Agent Service account?
From: Steve Thompson (stevethompson_at_nomail.please)
Date: 07/28/04
- Next message: Steve Thompson: "Re: Choose client net lib?"
- Previous message: Srini: "RE: IPSec policy between webserver and a clustered db server(SQL20"
- In reply to: Brian: "Changing SQL and Agent Service account?"
- Next in thread: Kevin McDonnell [MSFT]: "RE: Changing SQL and Agent Service account?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 28 Jul 2004 14:46:05 -0400
"Brian" <bpollard@idahodba.org> wrote in message
news:OCqXZ8KdEHA.3016@tk2msftngp13.phx.gbl...
> Are there any best practices recommending changing the SQL Server/Agent
> domain service account password? I assume you do not want to leave these
> the same forever after install, and I have a service pwd change utility
> without restarting SQL server, but not seeing a lot of talk about changing
> these account(s). Should they not change just like any other priveledged
> user?
>
If you change these accounts it is probably easiest to do so through
Enterprise Manager. If you have not read the following paper, I recommend
it:
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sp3sec02.mspx
while it does not make any firm recommendation on account/password changes,
this really should default (IMO) to whatever policy is in place in the
domain. More importantly, follow the recommendation of using a "service"
account that is not local system and is not an administrator on the server.
Steve
- Next message: Steve Thompson: "Re: Choose client net lib?"
- Previous message: Srini: "RE: IPSec policy between webserver and a clustered db server(SQL20"
- In reply to: Brian: "Changing SQL and Agent Service account?"
- Next in thread: Kevin McDonnell [MSFT]: "RE: Changing SQL and Agent Service account?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
