SQL Server 2014 Setup Question

Thomas Grassi
Thomas Grassi used Ask the Experts™
on
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

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Did you try to continue and install the SQL Server instance?
Thomas GrassiSystems Administrator

Author

Commented:
Vitor

No I was trying to get the firewall settings correct.

Thoughts
IT Engineer
Distinguished Expert 2017
Commented:
Don't worry with Firewall now since you don't even have a SQL Server instance installed.
Important now is to install SQL Server and then test it. You might be miss leading to some non existence issue at all.
Thomas GrassiSystems Administrator

Author

Commented:
Thanks

Will continue with install
Vitor MontalvãoIT Engineer
Distinguished Expert 2017

Commented:
Return here if you aren't successful with the install.
Cheers.

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