FIX: SQL Cluster: Error "Port 1433 in Use" on Alpha Platform (198169)


The information in this article applies to:

  • Microsoft SQL Server, Enterprise Edition 6.5
This article was previously published under Q198169
BUG #: 18417 (SQLBUG_65)

SYMPTOMS

On an Alpha platform with SQL Server 6.5 Enterprise Edition running in a cluster environment, when one SQL Server fails over to the other node so that both SQL Servers are running on the same node, the second SQL Server may report ODS error "Port 1433 is in use" in the SQL Server error log. As a result, users cannot log in to the second SQL Server by means of TCP/IP sockets.

This problem only occurs on the Alpha platform.

CAUSE

Under certain situations, the local environment variable _VDVAPI32_SERVER_NAME_ is not set properly, which causes the SQL Server to bind to the IP address of INADDR_ANY, rather than the virtual IP address.

WORKAROUND

To work around this problem, use Named Pipes as the alternative interprocess communication (IPC) application programming interface (API).

STATUS

Microsoft has confirmed this to be a problem in SQL Server 6.5. This problem has been corrected in Service Pack 5a for Microsoft SQL Server 6.5.For more information, click the following article number to view the article in the Microsoft Knowledge Base:

197177 INF: How to Obtain SQL Server 6.5 Service Pack 5a

For more information, contact your primary support provider.
Modification Type:MajorLast Reviewed:3/14/2006
Keywords:kbBug kbfix kbQFE KB198169
©2004 Microsoft Corporation. All rights reserved.