RE: Problem with sql2000 cluster installation

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 07/05/04 

Date: Mon, 05 Jul 2004 05:24:43 GMT

The virtual server option is only present for the Enterprise Edition of SQL Server 2000.

Were you using Enterprise Edition of SQL Server 2000? If yes and still the virtual server option is greyed out, can you post the sqlstp.log?

Also, MSDTC has nothing to do with this. Infact, you do not need MSDTC for SQL Server 2000 virtual server installation. You can configure MSDTC after installing SQL 2000 too.

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

Relevant Pages

  • Re: Adding a new node to a SQL server cluster
    ... On the Welcome screen of the Microsoft SQL Server Installation Wizard, ... click Virtual Server and specify the virtual server to which you want to add a node. ... On the Cluster Management screen, select the node and click Add. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Migrating stand-alone SQL server to cluster
    ... do I need to run the SP3a update on the cluster node again? ... So now I have one virtual server with 2 ... >> Troubleshooting SQL Server 2000 Failover Clusters ...
    (microsoft.public.sqlserver.clustering)
  • Re: Recreate Cluster
    ... There is no DNS or AD. ... >I support the Professional Association for SQL Server ... >> My plan is to completely deconstruct the cluster and SQL ... >> virtual server, reinstall operating systems on nodes, ...
    (microsoft.public.sqlserver.clustering)
  • Re: Rename SQL 2000 Virtual servers on Windows 2003 cluster
    ... but I'm just saying that I renamed the SQL server ... network name from VSVR1 to SQL1A and the named instance SQL1 continues to ... problems that may occur is that the SQL Server virtual server instance may no longer come online. ... The correct way to rename a clustered SQL Server 2000 virtual server is to remove and then reinstall SQL Server 2000 by using the new virtual server name. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Recreate Cluster
    ... Make sure and delete any 'tombstone' entries in DNS and AD and you should be ... I support the Professional Association for SQL Server ... > My plan is to completely deconstruct the cluster and SQL ... > recreate the cluster and virtual server with all the same ...
    (microsoft.public.sqlserver.clustering)