sql 2008 r2 install firewall warning

Posted on 2011-05-13
Last Modified: 2012-05-11
Was trying to install sql 2008 r2 on win 2008 r2, I got the following warning
Rule Check Result
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 for information about ports to open for each feature.

Do I need to disable firewall, or can I go ahead. How can i check if port 1433 is open?
Question by:sqlserverdba
    LVL 8

    Accepted Solution

    I would go ahead with the install. This warning will pop up no matter if the port is open or not. I got the message and never did anything with the firewall and all has worked fine since day one. However I will post the directions for checking the port momentarily.
    LVL 14

    Assisted Solution

    It's only a warning for you to notice that firewall is enabled and may block network traffic. In order to properly accept connections after installation you need to open port(s) on which SQL Server will listen (default is 1433).
    LVL 8

    Assisted Solution

    netsh firewall set portopening protocol = TCP port = 1433 name = SQLPort mode = ENABLE scope = SUBNET profile = CURRENT

    Run this script in cmd prompt and it will open the port.
    LVL 1

    Author Closing Comment

    I did not open the firewall, just went ahead with the install and there were no problems

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Sometimes drives fill up and we don't know why.  If you don't understand the best way to use the tools available, you may end up being stumped as to why your drive says it's not full when you have no space left!  Here's how you can find out...
    This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
    This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

    754 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now