I am in the process of trying to configure SQL Server 2008 to accept remote connections. I have been through all the documentation I can find and yet when I attempt to connect through management studio I get an error stating that the server could not be found.
Interestingly I can connect through telnet to the remote server via the port that sql server is listening on. In the SQL Server logs I can see the connection attempt. So SQL Server is up and running and listening on the correct port - no firewall blocking it.
It would appear that by default SQL Server is listening on port 50314 by default but management studio attempts to connect on port 1433.Weird.
Server Management Studio = no dice.
Anyone got any ideas? Server is set to allow remote connections - TCP IP is enabled, firewall is off.
UPDATE FOR TO CLEAR THINGS UP A BIT
We are seeing the connection attempt when we telnet in on port 50314 in the sql server logs. When we login through management studio we see it attempting connection on port 1433. There is no sign of this connection attempt in the logs.