Sql Server Firewall Problems

xtremereality
xtremereality used Ask the Experts™
on
Hi experts,
I am having a problem with Sql Server 2014 and the windows firewall.
The server is under the domain. In the firewall the port 1433 TCP and 1434 UDP are opened but I cannot connect to the server from remote.
If I disable the firewall for the domain network then I am able to connect to the server.
In any case, even with the firewall off, I can only connect using: servername\sqlinstance and not using the ip address of the server.
I doubled checked that TCP/IP is enabled in the SQL configuration and the port is 1433.
Basically with firewall on I cannot connect, with firewall off I can. The rule is set to open 1433 on private, domain and public.
Any idea what can be wrong?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
IT Engineer
Distinguished Expert 2017
Commented:
Is the SQL Server instance a named instance? If so it won't use port 1433 but a dynamic port.
You can use SQL Server Configuration Manager to change the port to a static one so you can add that port into the firewall rules.
xtremereality

Author

Commented:
Thanks :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial