We help IT Professionals succeed at work.
Get Started

SQL Server 2014 Setup Question

Last Modified: 2016-03-17
Windows 2012 R2 Standard VM
SQL 2014 Enterprise

Just starting to install SQL 2014

Using this link as my guide

I get the same warning as the article "Windows Firewall" warning

Rule "windows firewall' generated a warning

The windows firewall is enabled Make sure the appropriate ports are open to enable remote access. See the rules documentation at
http://go.microsoft.com/fwlink/?linkid=94001  for information about ports to open for each feature

So in my windows firewall I added the following inbound rules
Port 1433 TCP
Port 1434 TCP
Port 1434 UDP
Port 433 TCP
Port 4022 TCP
Port 135 TCP
Port 80 TCP

I still get the warning.

Each rule was defined the same way
local port specific port
Remote port All ports

local ip any
Remote ip  any


all checked.

If I turn off the firewall I can not access the internet and other network functions

What ports am I missing?
Watch Question
IT Engineer
Distinguished Expert 2017
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE