Skip to content

Specify Forums

Personal tools
You are here: Home » Specify Procedures » Opening your firewall for SQL Server

Opening your firewall for SQL Server

Document Actions
  1. Open security Center from the control panel. You will get this screen.
    Security Center
  2. Select to manage security settings for Windows Firewall. The firewall configuration dialog will appear.
    Firewall - General Tab
  3. Click the Exceptions tab at the top of the dialog.
    Firewall - Exceptions Tab
  4. Click the add program button.
    Firewall - Add Program
    Then click the browse button.
    Firewall - Browse
  5. Browse to the location of the program you want to grant access through your firewall to.
    For SQL 2000:
    The default location of the file is:
    C:\Program Files\Microsoft SQL Server\MSSQL\Binn\sqlservr.exe

    For SQL 2005:
    You will need to open up two files the default locations are:
    C:\Program Files\Microsoft SQL Server\90\Shared\sqlbrowser.exe
    and    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn\sqlservr.exe
  6. Click through the prompts to finish managing your firewall.
Created by cj
Last modified 2006-09-28 03:41 PM

Powered by Plone

This site conforms to the following standards: