How to open the firewall port for SQL Server on Windows Server 2008/R2

 

 

 

 

 

 

 

  • Click Start, click Run, type cmd, and then click OK.
  • At the command prompt, use the cd command to move to the folder in which you saved the OpenSqlServerPort.bat file.
  • To run the SQLopenports.bat script, type SQLopenports.bat at the command prompt, and then press Enter.
  • [DOWNLOAD]

    Applies to
    • Microsoft SQL Server 2005 Developer Edition
    • Microsoft SQL Server 2005 Enterprise Edition
    • Microsoft SQL Server 2005 Standard Edition
    • Microsoft SQL Server 2008 Developer
    • Microsoft SQL Server 2008 Enterprise
    • Microsoft SQL Server 2008 Standard
    • Microsoft SQL Server 2008 Web
    • Windows Server 2008 Datacenter without Hyper-V
    • Windows Server 2008 Enterprise without Hyper-V
    • Windows Server 2008 for Itanium-Based Systems
    • Windows Server 2008 Standard without Hyper-V
    • Windows Server 2008 Datacenter
    • Windows Server 2008 Enterprise
    • Windows Server 2008 Standard
    • Microsoft SQL Server 2008 R2 Developer
    • Microsoft SQL Server 2008 R2 Enterprise
    • Microsoft SQL Server 2008 R2 Standard
    • Microsoft SQL Server 2008 R2 Web
    • SQL Server 2012

    source – http://support.microsoft.com/kb/968872

     

    You can leave a response, or trackback from your own site.

    Leave a Reply