We have a brand new node that we added to an existing cluster. When we try to start the service, the error log shows:
Server TCP provider failed to listen on [x.x.x.x] <ipv4> 1433]. Tcp port is already in use.
The only difference I see on this box versus the other boxes is that under SQL Server Config, SQL Server 2005 Network Configuration, Protocols, TCP on the IP Addresses tab, at the bottom I see port 1433 for both TCP Dynamic Ports as well as TCP Port. The other servers just have an entry in Dynamic. I clear the TCP Port entry, try to restart, and it puts 1433 back in. Same effect if I remove it in the registry, it keeps re-adding itself. Any ideas?