Cannot connect to SQL Server 2005 from anywhere but localhost.
I have a SQL2K5 instance running on W2K3 Server Standard. From the local machine running SQL I can create ODBC connections and connect with SQL Server Management Studio with no trouble. Unfortunately, I cannot connect to the SQL Server with anything on any other machine. No ODBC, no Management Studio, nothing.
I have verified that remote connections are enabled via SQL Server Management Studio and the Surface Area Configuration tools, and made sure that the instance and the SQL Native Client has Named Pipers and TCP/IP enabled in the SQL Server Configuration - TCP/IP running on port 1433.
I can ping the SQL Server Machine from a remote box, and I can ping that remote box from the SQL Server Machine. Both machines are in the same workgroup, and on the same subnet.
Windows firewall is disabled on both machines.
I'm at a loss for what could possibly be going wrong.
Solution: Cannot connect to SQL Server 2005 from anywhere but localhost.
I have already enabled Remote Connections as described above. In fact, I just discovered the root of my issue - the SQL Server Browser service was not running on the SQL Server machine.
I started the SQL Server Browser and all is now well.