Solved

Sql Server Firewall Problems

Posted on 2016-09-06
2
84 Views
Last Modified: 2016-09-06
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?
0
Comment
Question by:xtremereality
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 50

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41786077
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.
0
 

Author Closing Comment

by:xtremereality
ID: 41786108
Thanks :)
0

Featured Post

How to Defend Against the WCry Ransomware Attack

On May 12, 2017, an extremely virulent ransomware variant named WCry 2.0 began to infect organizations. Within several hours, over 75,000 victims were reported in 90+ countries. Learn more from our research team about this threat & how to protect your organization!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In-place Upgrading Dirsync to Azure AD Connect
This article describes my battle tested process for setting up delegation. I use this process anywhere that I need to setup delegation. In the article I will show how it applies to Active Directory
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …

751 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question