I am hosting a MS SQL Express 2008 on a dedicated server located in LA.
It is installed, I fallow the direction to enable TCP/IP. I change the dynamic port to a static port. I can telnet from my home PC to that port without any timeout issue.
My question is I want to connect to it using "SQL Server Management Studio" Its 2005 manager. But where do i enter the port to connect? as if i connect by just entering the ip i get a error.