We help IT Professionals succeed at work.
Get Started

SQL Server 2014 Setup Question

1,253 Views
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
http://www.sqlcoffee.com/SQLServer2014_0005.htm

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

Scope
local ip any
Remote ip  any

Profiles
Domain
Private
Public

all checked.

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

What ports am I missing?
Comment
Watch Question
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
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