I just got a VPS with Windows Server 2008 on which I installed SQL Server 2008 Express. I am able to connect to this server fine with Shared Memory (default for localhost-running tools). However, I want to manage it remotely using SQL Server Management Studio on a remote workstation.
I have opened SQL Server Configuraion Manager, selected SQLEXPRESS as the service, and enabled Named Pipes and TCP/IP. I tried restarting the database and browser services and even tried rebooting the computer.
The user of all SQL services is Network Service.
I have verified in SQL Server Management Studio on the server itself that 'Allow Remote Connections' is enabled.
I have opened the Windows Firewall control panel and opened 1433/TCP and 1434/UDP (scoped to my remote workstation's IP), and have even tried turning the entire firewall off altogether.
On another machine, running Windows Vista and SQL Server 2008, I am able to remotely use telnet.exe to see if I can connect to its IP on port 1433. This works successfully, it connects fine. But I am unable to do the same thing when trying to use the IP of the Windows Server 2008 VPS I'm trying to set up.
In fact, if I open a cmd console while Remote Desktop'd on the server, I can't even connect to localhost on port 1433 with telnet.exe.
I've Googled and scoured and I can't find anything else to try.
UPDATE: It was pointed out to me that there both "Active" and "Enabled" settings in the Configuration Manager for TCP/IP. I had one set to true and one set to false. I don't know which is which, but I now have both set to true. However, after doing that and setting Port to 1433 and restarting the services and turning off the firewall again, I am still unable to remotely connect.