Article ID: 270126 - View products that this article applies to.
This article was previously published under Q270126
SQL Server 2000 only allows clustering of a single default instance per cluster. This means that when you upgrade a SQL Server 7.0 Active/Active cluster (two clustered default instances), you can only upgrade one of the instances in-place as a default instance. You must upgrade the other SQL Server 7.0 instance to a SQL Server 2000 named instance, by using the Copy Database Wizard.
SQL Server 2000 named instances listen on a dynamic port that is selected when the instance is first started. Existing pre-SQL Server 2000 clients are not able to connect to the named instance after the upgrade because the clients are expecting to be able to connect to a default instance that is listening on port 1433.
Client computers that do not have the SQL Server 2000 client utilities and/or Microsoft Data Access Components (MDAC) 2.6 are unaware of named instancing and therefore are only able to connect to the default instance. Hence, only a single virtual server is being used.
There are a few ways for clients to connect to both virtual servers. Because there should not be a problem connecting to the default instance of the SQL Server virtual server, this section focuses on what you can do with the second virtual server, the named instance.
REFERENCESFor additional information about the topics covered in this article, see the following topics in Microsoft SQL Server 2000 Books Online:
Contact us for more help
Connect with Answer Desk for expert help.