Tuesday, March 27, 2012

Error installing SQL 2000 on W2k3 cluster

When installing SQL 2000 on a W2K3 cluster, I get the following error: An
error occurred while creating virtual server resources for clustering.
Cluster specific registry entries couldn't be written. I followed the
instructions in KB872931 and I get the same results. Can anyone assist?
Kevin
All,
Never mind. starting the remote registry service on all nodes fixed the
problem.
Kevin
"Kevin Wheeler" <kevin.l.wheeler@.lmco.com> wrote in message
news:OMeIGELyEHA.2192@.TK2MSFTNGP14.phx.gbl...
> When installing SQL 2000 on a W2K3 cluster, I get the following error: An
> error occurred while creating virtual server resources for clustering.
> Cluster specific registry entries couldn't be written. I followed the
> instructions in KB872931 and I get the same results. Can anyone assist?
>
> Kevin
>
|||Kevin,
The error message "An error occurred while creating virtual server resources for clustering. Cluster specific registry entries couldn't be written" occurs when the SQL Server 2000 virtual server Setup program tries to
create the virtual server resources on the remote nodes in the failover cluster.
The KB872931 will be helpful only if your sqlstp.log had the errors as written in the MORE INFORMATION section of the KB.
Give us more information to be able to help you out.
Few qs that comes to mind :
1) Do you have Teminal Services installed on Win2K3 nodes? If yes, the you need to remove it. See KB 301520
2) Are you installing a named instance or a default instance of SQL2K virtual instance? If named instance, have created a named pipe alias for the server name as per KB 815431
3) Do you have mount volumes in the cluster? They are not supported for SQL 2K virtual instance. See KB 819546
4) Paste the sqlstp.log for us to look at
Interested in troubleshooting it yourself
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Upcoming Webcast
TechNet Support WebCast: How to install a Microsoft SQL Server 2000 virtual server on a Microsoft Windows Server 2003 cluster
Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003.
http://support.microsoft.com/default...b;en-us;888121
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||I understand that. I guess it need access to the remote nodes registry.
When the remote registry service was disabled, the install failed. When I
enabled it, the install completed with no errors.
Kevin
"Uttam Parui[MS]" <uttamkp@.online.microsoft.com> wrote in message
news:tPwDvzMyEHA.3436@.cpmsftngxa10.phx.gbl...
> Kevin,
> The error message "An error occurred while creating virtual server
resources for clustering. Cluster specific registry entries couldn't be
written" occurs when the SQL Server 2000 virtual server Setup program tries
to
> create the virtual server resources on the remote nodes in the failover
cluster.
> The KB872931 will be helpful only if your sqlstp.log had the errors as
written in the MORE INFORMATION section of the KB.
> Give us more information to be able to help you out.
> Few qs that comes to mind :
> 1) Do you have Teminal Services installed on Win2K3 nodes? If yes, the you
need to remove it. See KB 301520
> 2) Are you installing a named instance or a default instance of SQL2K
virtual instance? If named instance, have created a named pipe alias for the
server name as per KB 815431
> 3) Do you have mount volumes in the cluster? They are not supported for
SQL 2K virtual instance. See KB 819546
> 4) Paste the sqlstp.log for us to look at
> Interested in troubleshooting it yourself
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for
Failover Clustering
>
http://support.microsoft.com/default...ebcasts/wcd020
703/wcdblurb020703.asp
> Upcoming Webcast
> TechNet Support WebCast: How to install a Microsoft SQL Server 2000
virtual server on a Microsoft Windows Server 2003 cluster
> Discusses how to install Microsoft SQL Server 2000 clustering on
Microsoft Windows Server 2003 and differences between Microsoft Windows 2000
Server and Windows Server 2003.
> http://support.microsoft.com/default...b;en-us;888121
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
|||Glad to hear that you resolved the issue. You are correct. The "Remote Registry" service needs to be running on all cluster nodes during the installation.
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx

No comments:

Post a Comment