DetailPage-MSS-KB

Microsoft small business knowledge base

Article ID: 955784 - Last Review: September 19, 2008 - Revision: 1.0

SYMPTOMS

After you use Windows Cluster Administrator tool to change the network name of a Microsoft SQL Server 2008 Analysis Services failover cluster instance, you cannot use the SQL Server Setup program to modify the SQL Server 2008 Analysis Services failover cluster instance that has the changed network name.

CAUSE

This problem occurs because the name for the cluster instance is not changed in the registry when you perform the change in a tool that is not a part of SQL Server.

RESOLUTION

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows
To resolve this problem, change the cluster name in the registry on each node in the failover cluster. To modify the cluster name on a node in the cluster, follow these steps.

Note The node can remain online because the registry entry is only used by the Setup program.
  1. Start Registry Editor.
  2. Locate and then click the following registry subkey:
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSAS10.<InstanceId>\Cluster
  3. In the details pane, right-click ClusterName, and then click Modify.
  4. Type the correct cluster name in the Value Data box, and then click OK.
  5. On the File menu, click Exit.
  6. Repeat step 1 through step 5 on each node in the cluster.

APPLIES TO
  • Microsoft SQL Server 2008 Enterprise
  • Microsoft SQL Server 2008 Standard
  • Microsoft SQL Server 2008 Developer
Keywords: 
kbregistry kbsetup kbclustering kbtshoot kbprb KB955784
Share
Additional support options
Ask The Microsoft Small Business Support Community
Contact Microsoft Small Business Support
Find Microsoft Small Business Support Certified Partner
Find a Microsoft Store For In-Person Small Business Support