SQL Server 2008 remote connection issue via SSMS
Posted on 2012-04-11
I am really pulling my hair out with SMSS and a new install of SQL Server 2008 R2 (WEB edition). I think I forgot to allow "Remote CDOnnections" on install. I know I can do this via Management Studio Express on the server, but we can not install it due to the stupid trial license bug that there have been thousands of complaints about.
Anyways, what I would like to do is use SMSS on my local dev machine to connect to my sql server but alas it will not connect;
On the server I have opened up all required ports and I have enabled TCP/IP connections using the external Ip address, but still I cannot connect to the server from my remote machine! SO, I am guessing this is the 'allow remote connections' problem?
Could it be anythign else?
Is there anyways to enable 'remote connections' via a command prompt for sqlserver 2008 r2?