Domain Rename - Sql Server 2005 Failover Cluster Impact

Question

Post reply

Domain Rename - Sql Server 2005 Failover Cluster Impact

blue_inelush

Ten Centuries

Points: 1118
More actions
February 24, 2011 at 12:38 am

#147402

Hello everybody...

Please can you help me with some suggestions about the follow fact:

We are changing this weekend our company domain name. This involves many changes. But between them, I have a SQL Server 2005 Cluster server which has to be made to run very quick in order that the bussiness activity not to be stopped for more than few hours.

I haven't made the installation and the configuration for this cluster. All that I know is that all the services are running under Domain Groups.

I really don't know what to do with minimum downtime and even without reinstalling/reconfigure.

Have you ever done this? Can you tell me how did you make it?

Thanks.

Wish you good ideas! 🙂
Andreea

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

crazy4sql SSCoach Points: 19590 More actions · Answer 1

As your sql already running and to make the change effective in your sql , you have to change the sql services running account to the correct domain account if services are configured on old domain user(admin) name.

For this, you have to change the service account details and same in the secondary server as well. Do failover to check if new account is being configured properly and sql working with new account.

I dont think it will be much time consuming but still you have to take downtime for sql server service account configuration. If its your 1active 1 passive environment then I think 10 min is sufficient enough. Just make sure account already created in domain with proper permission in sql and windows.

----------
Ashish