Cannot connect to Active/Passive SQL2005 Failover Cluster via TCP/IP
Posted on 2008-10-04
I've installed a new active/passive SQL2005 failover cluster, everything *appears* to be fine, but I cannot connect to the SQL virtual server via TCP/IP. Named pipes works fine, but I need TCP/IP. I have run the Surface Area Configuration tool and tried both TCP/IP only and TCP/IP + Named Pipes to no avail. Cluster fails between the two nodes without error, runs fine when connecting via named pipes.
I've successfully implemented several SQL2000 failover clusters but this is my first SQL2005. Any help would be appreciated.
O/S is Windows 2003 Enterprise R2 SP2 x64. SQL2005 Standard x32.