BUG: Virtual SQL Server 2000 installations may fail if you try to install SQL Server 2000 to Windows 2000 domain controllers (298570)


The information in this article applies to:

  • Microsoft SQL Server 2000 Enterprise Edition
This article was previously published under Q298570
BUG #: 352185 (SHILOH_BUGS)

BUG #: 353952 (SHILOH_BUGS)

SYMPTOMS

The SQL Server setup, for SQL Server 2000 and its service packs, may cause an Access Violation (AV) in the SQL Server Setup User Interface on a cluster setup when either or both nodes are domain controllers. If both nodes (of a two node cluster) are domain controllers, the unhandled Access Violation may occur when the setup authenticates the service account. When the AV occurs, the setup either stops responding (hangs) or the installation disappears from the screen leaving the setup files running in the background. Alternately, a machine name in excess of 15 characters on the domain controller may also cause the installation to fail.

NOTE: On a Microsoft Windows NT Server, Enterprise Edition 4.0-based computer, Microsoft recommends that you make cluster nodes backup domain controllers. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:

171390 Cluster Service May Not Start if Domain Controller Is Unavailable

However, if a domain controller is already local, or if there is reliable high-speed connectivity to a domain controller available, Microsoft does not recommend implementing a domain controller on cluster nodes on Microsoft Windows 2000-based computers.

281662 Windows 2000 Cluster Nodes as Domain Controllers

WORKAROUND

To work around the problem, install SQL Server to a Microsoft Windows 2000 Cluster whose nodes are not domain controllers that have local or high-speed connectivity to a Microsoft Windows 2000 domain controller.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 2000.

MORE INFORMATION

Steps to Reproduce the Behavior

  1. Install Windows 2000 on both nodes.
  2. Set up the Microsoft Cluster Service on both nodes.
  3. Run DCPromo on both nodes to promote them to Domain Controllers.
  4. Insert your SQL Server 2000 Enterprise CD.
  5. Select to install SQL Server.
  6. Perform the installation as you normally would. An AV occurs about 60 seconds after you press Next in the screen that prompts you for the account information for use with the Virtual Server.
For additional information about installing standalone SQL Server on a NT Cluster, click the article number below to view the article in the Microsoft Knowledge Base:

289828 PRB: SQL Server Setup in a Cluster Environment Encounters an Access Violation If You Have a Long Computer Name

Modification Type:MinorLast Reviewed:4/6/2006
Keywords:kbtshoot kbBug kbpending KB298570 kbAudITPRO kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.