I have setup SQL Server express R2 on WIndows Server 2008 R2 and i can connect locally with SQL Management studio.
Remotely with the firewall enabled i cannot connect.
If i disable the firewall then remotely i can connect.
THis is very strange.
My firewall setting is set to TCP 1433 (although i also added 1434 as well)... but it refuses to work.
In the SQL Express R2 i have TCP/IP Enabled and it listens on 1433
Any help really appreciated, i am little lost. I have searched the net and i believe i am doing everything correctly.
Thanks in advance