Changing SQL Server configuration in a cluster environment

I running SQL Server on a Windows active passive cluster and need to change SQL Server configuration. If I change the configuration thru the virtual server the change is applied to the active node what happens to the passive node? Is it necessary for me t
o failover and apply the change there too?
Hi
Most configuration settings are stored in Master, which is shared.
If is recommended to fail over to the other nodes after you make a
configuration change as a test, you don't want to find out weeks down the
line that the failover failed because of a setting that was not identical on
all nodes.
There area a few settings in the registry under
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer ", especially
"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \MSSQLServer" where
settings like LoginMode, AuditLevel and ListenOn are stored.
Cheers
--
Mike Epprecht, Microsoft SQL Server MVP
Epprecht Consulting (PTY) LTD
Johannesburg, South Africa
Mobile: +27-82-552-0268
IM: mike@.epprecht.net
Specialist SQL Server Solutions and Consulting
MVP Program: http://www.microsoft.com/mvp
"Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> I running SQL Server on a Windows active passive cluster and need to
change SQL Server configuration. If I change the configuration thru the
virtual server the change is applied to the active node what happens to the
passive node? Is it necessary for me to failover and apply the change there
too?
|||Your're so right about that.
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Most configuration settings are stored in Master, which is shared.
> If is recommended to fail over to the other nodes after you make a
> configuration change as a test, you don't want to find out weeks down the
> line that the failover failed because of a setting that was not identical on
> all nodes.
> There area a few settings in the registry under
> "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer ", especially
> "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer \MSSQLServer" where
> settings like LoginMode, AuditLevel and ListenOn are stored.
> Cheers
> --
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Epprecht Consulting (PTY) LTD
> Johannesburg, South Africa
> Mobile: +27-82-552-0268
> IM: mike@.epprecht.net
> Specialist SQL Server Solutions and Consulting
> MVP Program: http://www.microsoft.com/mvp
> "Jerrick D.H" <JerrickDH@.discussions.microsoft.com> wrote in message
> news:301F2959-3BC0-4E96-8F55-838AC4813BA3@.microsoft.com...
> change SQL Server configuration. If I change the configuration thru the
> virtual server the change is applied to the active node what happens to the
> passive node? Is it necessary for me to failover and apply the change there
> too?
>
>