MS SQL: Can't connect to server with anything but 127.0.0.1 on the server machine I'm not able to connect to sql server with anything but 127.0.0.1 on the server machine.  If I try to connect via actual IP on the network it does not work locally or remotely.  

The environment is SQL Server 2005 on Windows Server 2000.  My goal is to connect to this SQL Server instance from a remote machine.

I've tried telneting to port 1433 using the actual IP and that fails.
I've tried turning off Windows Firewall completely

Any ideas or help is greatly appreciated!
Thanks
Are you running multiple instances?

Make sure that TCP connections are enabled.

Make sure a connection is allowed by your firewall, or that the firewall is disabled.

If you have trouble with either of these after making changes, try re-starting the DB and SQL Server Browser (or disable Browser).