My Favorite Blogs

Monday, September 28, 2009

Best practices of Password Change on SQL Failover cluster (Applicable n+1 nodes cluster)

As per my experience, I could suggest the following steps will help to change periodic password change on SQL Service account password on your Active/Passive and n+1 node cluster environment.

Important note: This activity is required downtime, make sure you informed your business about this outage.

Use RDP to log into each physical node of the cluster

Chaning password for Windows Cluster services.

Executed directly by: Start Run and enter Services.msc

1. Change password for windows cluster services.

Chaning password for SQL Services.

Executed directly by: StartRun and enter SQLServerManager.msc(SQL 2005) or SQLServerManager10.msc(SQL 2008)

2. In SQL Server Configuration Manager Change the Pwd for SQL services. Start from Active node.
3. Change 1st Active instance and change its other passive nodes

Once password change on all SQL services on Active and Passive nodes, SQL Instances need to be failed over to all cluster nodes to ensure that the password updated on all.

Failover test on Cluster Administrator.

Executed directly by:Start Run and entering cluadmin.exe

4. Once done on all nodes, failover the instances to another nodes and make the pwd get effected.

6. Restart the Cluster services on each nodes to make the pwd get effected.

This tip is applicable for SQL Server 2000 and 2005 on Windows 2000 & 2003 Cluster.


Wednesday, September 16, 2009

SQL Server Service Broker example on how to configure, send and receive messages

SQL Server 2008 and 2005 offer the Service Broker feature. In this tip we will go through the different components of service broker and step by step on how to setup Service Broker for a single database. Read further