Home Forums SQL Server 2005 Administering How to change configurations for both active and passive nodes in sql server 2005 2 node cluster. RE: How to change configurations for both active and passive nodes in sql server 2005 2 node cluster.

  • November 21, 2014 at 2:01 am

    #1760038

    Joy Smith San (11/21/2014)

    Thank you very much.!

    So a failover is essential is it ?

    We will failover and then faiolver back once again as we need the current node as active.

    Thanks once again.

    No need to do that. Change it on the active node. Period.

    It's a SQL Server setting that travels with the instance when you fail it over to the passive node.

    -- Gianluca Sartori