Monday, March 26, 2012

Rename SQL Server 2005 Virtual Server

Hi everybody,
I'm having a big problem when I want to rename my Failover Clustered SQL
Server 2005 Virtual Server. I've followed the indications given in this
how-to: http://msdn2.microsoft.com/en-us/library/ms178083.aspx but when I
try to bring my SQL Server online (after changing the network name, of
course...) I get this error:
[sqsrvres] GetRegKeyAccessMask: Could not get registry access mask for
registry key Software\Microsoft\Microsoft SQL Server\MSSQL.3\Cluster (status
0))
If I return back to the Virtual Server's old name I can bring SQL Server
online allright...
I've found no information about this error. Can anybody help me?
Thanks in advance,
Petrus
Create the following regkey:
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsof t SQL Server\MSSQL.3\Cluster]
"ClusterName"="<NewVirtualServerName>"
I had the same problem, and MSSQL.3 referred to Reporting Services. I'm guessing that since Reporting Services isn't cluster aware, the parameters aren't updated (or even created). But when SQL starts all its instances up, it gets confused that the parameter isn't there to change.
However, this still didn't have the desired result for me. The database engine and the OLAP services were MSSQL.4 and .5 respectively. The cooresponding Cluster keys as above continually renamed themselves back to the old name.
-Tom Kretzmer
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com
|||Sorry to post an update so soon. Just update MSSQL.4 and .5 on both nodes of the cluster and restart resources. For some reason "select @.@.servername" still comes up as the old instance name, but everything else works as it should.
EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

No comments:

Post a Comment