Can't Change Registry keys in Failover Clustering

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Can't Change Registry keys in Failover Clustering

Author

Topic

Maggi
Starting Member

2 Posts

Posted - 2004-12-28 : 12:14:11

Plat form: Windows 2003 enterprise ed,
SQL Server 2000 Failover Clustering SP3A enterprise ed.
Action: Change some registry keys after bring SQL resources offline.

I am trying to change the following registry keys to point to new location on registry at
Master node, member node and virtual server. However, Sytem didn't allow me to change. The Keys changed themself back after I brought SQL resources back online or reboot nodes:
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer
FullTextDefaultPath
E:\DATA\MSSQL\FTDATA

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Replication
WorkingDirectory
E:\DATA\MSSQL\REPLDATA

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup
SQLDataRoot
E:\DATA\MSSQL

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\SQLServerAgent
WorkingDirectory
E:\DATA\MSSQL\JOBS

There must be somewhere hidden in the registry to override those keys I did change. Can anyone help me figure out how to change those keys in failover clustering? Is there anyone with such expience? how do you fix that?

MichaelP
Jedi Yak

2489 Posts

Posted - 2004-12-28 : 12:49:25

Have you tried to change these paths in Enterprise Manager??

Michael

<Yoda>Use the Search page you must. Find the answer you will.</Yoda>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources