asked on Sql Server Firewall Problems
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?
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?
Microsoft SQL ServerSoftware FirewallsWindows Server 2012Microsoft Server OSActive Directory
Last Comment
xtremereality
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks :)