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 read and tried instructions from these Microsoft articles:
here
here
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?
Best Answer
Port 3306 if for mySQL.
Ports 1433 and 1434 are for MS SQL server. I would advice you to configure your firewall to allow traffic for TCP/UDP on these ports.