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

• Microsoft SQL Server, Enterprise Edition, version 6.5

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 version 6.5. This problem has been corrected in U.S. Service Pack 5a for Microsoft SQL Server version 6.5. For information about downloading and installing the latest SQL Server Service Pack, see http://support.microsoft.com/support/sql/.

For more information, contact your primary support provider.

Additional query words: active/active connectivity clustered clustr clustred errorlog

Keywords          : SSrvNet_Lib SSrvODS kbbug6.50 kbfix6.50.SP5 
Version           : winnt:6.5
Platform          : winnt 
Issue type        : kbbug 

Last Reviewed: July 19, 1999