Re: Changing SQL Service account passowrd on a cluster configurati

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

LInchi's advice on using the services applet on each node is a bit more complex, but it is a certaintly.

As for when changes "take", AD may need up to fifteen minutes to replicate the password change through the system when you have multiple controllers. If an account is logged in to a resource, such as a service account already running, you can leave it running or a while before changing it. The system will not force it out immediately but the application may no longer be able to access network resources after some time.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Mehul" <Mehul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7F18E2CD-E089-4642-898E-FB303324181E@xxxxxxxxxxxxxxxx
Thanks Geoff. But I would really like to know what are the steps to perform.
Do I need to change password on both the nodes or only on the active node ?
Once the password for the account is updated in AD, is it immediately
reflected on the SQL servers ?

"Geoff N. Hiten" wrote:

For the cluster service account password:
http://support.microsoft.com/kb/305813/en-us

For the SQL 2005 Instance, use the SQL Configuration Manager to change the
password. It handles the "cluster magic".

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Mehul" <Mehul@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C4EE5D43-00E3-4322-92C2-538B8CDEC12D@xxxxxxxxxxxxxxxx
> Hi,
> I have SQL 2005 server (with Named Instance) running on a two node > Cluster
> Configuration (Active/Passive).
>
> SQL Instance, SQL Server Agent, SQL Server Browser services are running
> under a service account (domain account). Similarly Cluster service is
> also
> running under a cluster service account (domain account).
>
> I am looking for accurate steps to update password of SQL Service > account
> and Cluster service account that will cause minimum disruption of these
> services. If there’s a link to documentation on how to update password,
> that
> will be most useful.
>



.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)