Avatar of Member_2_6492660_1
Member_2_6492660_1
Flag for United States of America

asked on 

SQL Server 2014 Setup Question

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?
Microsoft SQL ServerWindows Server 2012Software Firewalls

Avatar of undefined
Last Comment
Vitor Montalvão

8/22/2022 - Mon