Microsoft KB Archive/198169

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

Article ID: 198169

Article Last Modified on 3/14/2006

-

APPLIES TO


 * Microsoft SQL Server 6.5 Enterprise Edition

-



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.

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

Keywords: kbbug kbfix kbqfe KB198169

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.