RE: Changing SQL and Agent Service account?

From: Kevin McDonnell [MSFT] (kevmc_at_online.microsoft.com)
Date: 07/29/04 

Date: Thu, 29 Jul 2004 00:47:17 GMT

I guess this all depends upon your Security Policy that you have in place.

The service accounts should be running under a low privilege domain acount
and should be changed
based upon the password expiration you've set for other domain accounts.
So, yes I believe they should be changed.

Typically, you modify the account within SEM, but here's an article on how
to do it outside of SEM.

283811 How to change the SQL Server or SQL Server Agent Service account
without
http://support.microsoft.com/?id=283811

Thanks,

Kevin McDonnell
Microsoft Corporation

This posting is provided AS IS with no warranties, and confers no rights.

Relevant Pages

  • Re: SQL 2000 Problems on One Node Only
    ... Since both the Cluster and SQL Server service accounts are Local ... how is SQL Server set up to allow Local Administrators to log into SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: How to change service accounts on a cluster
    ... SQL Server Configuration Manager I always get the same error: ... to use SQL Configuration Manager to change the service accounts. ... click "OK" it says - specified network password is incorrect. ...
    (microsoft.public.sqlserver.clustering)
  • SQL Server Setup could not validate the service accounts
    ... Microsoft SQL Server 2005 Setup ... SQL Server Setup could not validate the service accounts. ... or the specified username or password is incorrect. ... service, specify a valid username, password, and domain, or specify a ...
    (microsoft.public.sqlserver.setup)
  • RE: SQL Server Setup could not validate the service accounts
    ... Microsoft SQL Server 2005 Setup ... > SQL Server Setup could not validate the service accounts. ... or the specified username or password is incorrect. ... > service, specify a valid username, password, and domain, or specify a ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL server disable in active directory
    ... Did you switch the SQL Server service accounts from Local System to Local or Domain User accounts or was there a switch in the service account names? ...
    (microsoft.public.sqlserver.server)