Re: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings

From: "Rick Byham, \(MSFT\)" <rickbyh@xxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 23 Sep 2008 08:36:56 -0700

I can't see the warning at the moment but my recollection is that is just warns you that the firewall is on and you might have to configure it. Since setup doesn't know what you want to do with SQL Server it can't tell if you have configured it correctly. So it still warns, but the warning doesn't stop you from continuing.
--
Rick Byham (MSFT), SQL Server Books Online
This posting is provided "AS IS" with no warranties, and confers no rights.

"Omid Golban" <OmidGolban@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:67E8EAC9-6FCE-48B6-BB02-4C2A58563047@xxxxxxxxxxxxxxxx

Hello,
I am installing default instance of SQL Server 2008 x64 on Windows Vista
Enterprise (x64). I get the warning on windows firewall: rule "Windows
Firewall" generated a warning.
I am including these at the bottom of this post:
1. ports that I have opened
2. installation steps and the warning message
3. results of netstat -n -a
Why am I getting this warning?
How do I find out what other IP address has to be opened?
How can I get rid of this warning and continue with my installation?

Thank you,
Omid Golban

Following the instruction on http://go.microsoft.com/fwlink/?LinkId=94001 I
have opened up follwoing ports:
80 TCP - SQL Server Report Server
135 TCP - SQL Server Integration Services
443 TCP - SQL Server default instance over HTTPS
1433 TCP - SQL Server SQL2008
1434 TCP - SQL Server Dedicated Admin Connection
1434 UDP - SQL Server Browser
2382 TCP - SQL Server Browser Service
2383 TCP - SQL Server Analysis Services
4022 TCP - SQL Server Service Broker
4500 UDP
& 500 UDP - IPSec traffic

Below are the installation steps followed by results of netstat -n -a:
1. Launch "New SQL Server stand-alone installation or add features to an
existing installation"
2. Setup Support Rule shows all six operations completed (passed):
2.1 min os version
2.2 setup administrator
2.3 restart computer
2.4 windows management instrumentation (WMI) serivce
2.5 consistency validation for SQL server register keys
2.6 long path names to files on SQL server installation media
3. Setup Support Files: Install components required for SQL Server setup:
10 passed, 1 warning (none failed, none skipped)
3.1 Fusion Active Template Library (ATL)
3.2 Unsupported SQL Server products
3.3 Performance counter registry hive consistency
3.4 previous releases of SQL server 2008 BI deleopment studio
3.5 Previous CTP installation
3.6 consistency validation for SQL server registry keys
3.7 computer domain controller
3.8 MS .NET application registry
3.9 Edition WOW64 platform
3.10 Windows PowerShell
3.11 Windows Filewall - gives 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.

C:\>netstat -n -a
Active Connections
Proto Local Address Foreign Address State
TCP 0.0.0.0:21 0.0.0.0:0 LISTENING
TCP 0.0.0.0:25 0.0.0.0:0 LISTENING
TCP 0.0.0.0:80 0.0.0.0:0 LISTENING
TCP 0.0.0.0:135 0.0.0.0:0 LISTENING
TCP 0.0.0.0:443 0.0.0.0:0 LISTENING
TCP 0.0.0.0:445 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1044 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1055 0.0.0.0:0 LISTENING
TCP 0.0.0.0:1433 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2382 0.0.0.0:0 LISTENING
TCP 0.0.0.0:2967 0.0.0.0:0 LISTENING
TCP 0.0.0.0:3389 0.0.0.0:0 LISTENING
TCP 0.0.0.0:8080 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1139 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1149 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1434 0.0.0.0:0 LISTENING
TCP 127.0.0.1:1839 0.0.0.0:0 LISTENING
TCP 172.16.8.18:139 0.0.0.0:0 LISTENING
TCP 172.16.8.18:1122 172.16.2.201:5060 ESTABLISHED
TCP 172.16.8.18:1142 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1145 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1184 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1185 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1186 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1188 172.16.1.25:1301 ESTABLISHED
TCP 172.16.8.18:1190 172.16.1.25:1301 ESTABLISHED
TCP 172.16.8.18:1191 172.16.1.25:1301 ESTABLISHED
TCP 172.16.8.18:1192 172.16.1.25:1301 ESTABLISHED
TCP 172.16.8.18:1212 172.16.1.52:1025 ESTABLISHED
TCP 172.16.8.18:1335 172.16.8.138:445 ESTABLISHED
TCP 172.16.8.18:1436 172.16.1.28:445 ESTABLISHED
TCP 172.16.8.18:1459 207.46.16.248:80 CLOSE_WAIT
TCP 172.16.8.18:7538 0.0.0.0:0 LISTENING
UDP 0.0.0.0:445 *:*
UDP 0.0.0.0:500 *:*
UDP 0.0.0.0:1121 *:*
UDP 0.0.0.0:1189 *:*
UDP 0.0.0.0:1434 *:*
UDP 0.0.0.0:3456 *:*
UDP 0.0.0.0:4500 *:*
UDP 127.0.0.1:123 *:*
UDP 127.0.0.1:1025 *:*
UDP 127.0.0.1:1027 *:*
UDP 127.0.0.1:1128 *:*
UDP 127.0.0.1:1295 *:*
UDP 127.0.0.1:1900 *:*
UDP 172.16.8.18:123 *:*
UDP 172.16.8.18:137 *:*
UDP 172.16.8.18:138 *:*
UDP 172.16.8.18:1900 *:*

Follow-Ups:
- Re: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warni
  - From: Geraldo

References:
- installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
  - From: Omid Golban

Prev by Date: Re: SQL Server 2000: Can't get the trans log to shrink
Next by Date: Re: Installing SQL Server Developer's Edition
Previous by thread: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
Next by thread: Re: installing SQL 2008 x64 on Vista Enterprise x64-Firewall warni
Index(es):
- Date
- Thread

Relevant Pages

installing SQL 2008 x64 on Vista Enterprise x64-Firewall warnings
... I am installing default instance of SQL Server 2008 x64 on Windows Vista ... Firewall" generated a warning. ... How can I get rid of this warning and continue with my installation? ... 135 TCP - SQL Server Integration Services ...
(microsoft.public.sqlserver.setup)
Problem with installing MS SQL Server 2005 - Express Edition
... I was trying to install MS SQL Server 2005 Express edition. ... This warning appears in the list of 12 items that are being cecked at the ... "An installation package for the product Microsoft SQL Server Native Client ...
(microsoft.public.sqlserver.setup)
Re: Problem with installing MS SQL Server 2005 - Express Edition
... client it basically says to uninstall the native client through add/remove ... > I was trying to install MS SQL Server 2005 Express edition. ... > This warning appears in the list of 12 items that are being cecked at the ... > "An installation package for the product Microsoft SQL Server Native ...
(microsoft.public.sqlserver.setup)
SQL Server bind problem
... installed SQL Server 2000 on a 2003 Enterprise installation. ... is set for port 1443 in the SQL network client network util. ... TCP 212.22.96.208:3389 212.22.96.50:3075 ESTABLISHED ...
(microsoft.public.sqlserver.server)
Re: Stupid SQLCE warning message
... you just pretend you did not see ... >> I am trying to replicate SQL Server Database to SQLCE and solving one ... >>>Incorrect Deployment Warning ... >> How can I ignore this messae and start application in debug mode from ...
(microsoft.public.dotnet.framework.compactframework)