I have MS SQL Server Express running on Windows Server (both AMD64, 2008 R2). MSSQL is configured for remote access. This access works fine when I disable the firewall entirely. It stops working when I enable the firewall.
I've added both TCP and UDP incoming exceptions on the server for the port used (set to 3306) and for the executable: C:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS\MSSQL\Binn\sqlservr.exe I've set the firewall rules to apply to all domains. Still, no connection.
Nothing fancy here: No ActiveDirectory, no domain, no layer 3 switching, just a simple SQL Server Authentication connection from a workstation connected to the same physical switch as the server.
Aside from disabling the firewall, does anyone know how to fix this?