Can't connect SQL2008 when firewall sbs2011 is active
Posted on 2011-09-16
I’m using a Windows SBS2001 with SQL express 2008r2.
When a client tries to connect the SQL server it doesn’t work. The connection is probably blocked by the SBS2001 firewall. If I turn the firewall off, then the client can connect to the SQL database.
I tried many thing, but they didn’t help.
- Allow incoming tcp port 1433 in the server firewall
- In the SQL server configuration manager under “Protocols for SQL Express “
I configured the tcpip protocol: tcp port: 1433, dynamic port – (and also tried different combinations)
So basically, when I turn off the server 2011 firewall, I can connect to the SQL database. But I want to make it work when firewall’s active.