You are currently offline, waiting for your internet to reconnect

Error message when you change the IP address on a SQL Server failover cluster node: "Bind failed"

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

This article was previously published under Q319578
SYMPTOMS
Attempts to bring a SQL Server 2000 or SQL Server 2005 virtual instance online on a cluster may fail, or the SQL Server virtual instance on the cluster may come online successfully, but the SQL Server virtual instance on the cluster will only listen on Named Pipes. Client connections made over Named Pipes will succeed, but client connections over TCP/IP fail.

The SQL Server error log reports the following error message if the Virtual SQL Server does not successfully bind to port 1433:
SuperSocket Info: Bind failed on TCP port 1433
If the Virtual SQL Server is set to bind to 0 or a dynamic port, the Virtual SQL Server still unsuccessfully binds and an error message similar to the following occurs:
SuperSocket Info: Bind failed on TCP port 0
This article discusses one possible cause of this error message. The information in this article helps only if you are experiencing this exact same scenario. For other possible causes of the error message, see the following articles in the Microsoft Knowledge Base:
293107 PRB: TCP\IP Port in Use by Another Application
312935 FIX: SQL Server fails to bind TCP/IP port at startup
308091 BUG: Hide Server Option Cannot Be Used on Multiple Instances of SQL Server 2000
307197 PRB: SQL Virtual Cluster Server Fails to Bind to the Port on Which it is Listening
CAUSE
Changing the Virtual SQL Server IP address with the Cluster Administrator tool. For a default instance of virtual SQL Server, the following registry value points to a previous IP address:

HKLM\Software\Microsoft\MSSQLServer\Cluster


For a named instance of virtual SQL Server, the following registry value points to a previous IP address:

HKLM\Software\Microsoft\Microsoft SQL Server\Instance Name\Cluster\ClusterIpAddr
RESOLUTION
To resolve the problem, follow the steps in Microsoft Knowledge Base article Q244980 for the correct way to change the Virtual SQL Server IP address. When you get to step 7 in the "More Information" section of the article, select Remove and replace an existing IP Address:
244980 HOW TO: Change the Network IP Addresses of SQL Server Virtual Servers
If you are using SQL Server 2005, follow the steps described in the "How to: Change the IP Address of a SQL Server 2005 Failover Cluster" topic in SQL Server Books Online to resolve the problem.
sockets 10061
Properties

Article ID: 319578 - Last Review: 04/06/2006 20:26:24 - Revision: 9.2

Microsoft SQL Server 2000 Standard Edition, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition

  • kbsql2005cluster kbprb KB319578
Feedback
>style="display:none;" onerror="var m=document.createElement('meta');m.name='ms.dqp0';m.content='true';document.getElementsByTagName('head')[0].appendChild(m);" onload="var m=document.createElement('meta');m.name='ms.dqp0';m.content='false';document.getElementsByTagName('head')[0].appendChild(m);" src="http://c1.microsoft.com/c.gif?">