SQL server listening on 127.0.0.1:1433 only, and not on all the IP addresses on the server
Posted on 2004-04-16
I have this server which has two public IP addresses. Its a windows 2000 server with SQL 2000 on it We changed the NIC on it yesterday since it was having problems. Now, the clients cannot connect to the server. I tried doing a telnet to the IP addresss on the server itself , but it wont connect. When i checked the error log, I saw this - SQL server listening on 127.0.0.1:1433. The error log of yesterday had the other two IP addresses as well. How do i get the server to listen on those two as well. PLease help.