How to change SQL Server parameters in a clustered environment when SQL Server is not online

http://support.microsoft.com/kb/953504

=====================================================================================

1. Click Start, click Run, type regedit, and then click OK.
2. Locate the quorum disk. To do this, follow these steps:
1. Locate the following registry key:
HKEY_LOCAL_MACHINE\Cluster\Quorum
2. The Path entry contains the path of the quorum disk. For example, the Path entry contains the following path:
:\MSCS
3. Locate the GUID of the SQL Server cluster resource. To do this, follow these steps:
1. Locate the following registry key:
HKEY_LOCAL_MACHINE\Cluster\Resources
2. Examine the Name column of the registry entries.

Note Several registry entries include "GUID" in the name of the entry.
3. For the default instance, locate the SQL Server cluster resource that includes "SQL Server" in the Name column.

For named instances, locate the SQL Server cluster resources that include "SQL Server ()" in the Name column.
4. Locate the checkpoint file name. To do this, follow these steps:
1. Locate the following registry key:
HKEY_LOCAL_MACHINE\Cluster\Resources\{GUID}\RegSync
2. In the details pane, view the checkpoint registry hives and the corresponding numbers that resemble the following:
For the default instance
00000004 SOFTWARE\Microsoft\Microsoft SQL Server\MSSQLSERVER

For a named instance
00000004 SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.X\MSSQLSERVER
Note For a named instance, X corresponds to the instance ID.

The number is the checkpoint file name. In this example, the checkpoint file name is 00000004.cpt.
5. In Registry Editor, click HKEY_LOCAL_MACHINE.
6. On the File menu, click Load Hive.
7. In the :\ folder, locate the checkpoint file that you found in step 4.
8. In the Key Name box, type 1, and then click OK.
9. Locate the following registry key to correct the invalid checkpoint registry key value:
HKEY_LOCAL_MACHINE\1\
Note The following examples correct the MSSQLSERVER checkpoint registry key:
* Example 1
To correct the invalid path of the Master.mdf file, follow these steps:
1. Locate the following registry key:
HKEY_LOCAL_MACHINE\1\Parameters
2. Correct the SQLArg0 key.
* Example 2
To disable the incorrectly enabled VIA protocol, follow these steps:
1. Locate the following registry key:
HKEY_LOCAL_MACHINE\1\SuperSocketNetLib\Via
2. Change the value of the Enabled entry from 1 to 0.
10. After you correct the registry key, click HKEY_LOCAL_MACHINE\1, click the File menu, and then click Unload Hive.

Note After you follow these steps, this checkpoint is fixed and is replicated to the specific node automatically during failover. You can bring the instance of SQL Server online.
=====================================================================================