Microsoft Fix it BLOG

Automated solutions that are easy, intuitive, and available when and where you need them. Browse for solutions or sign in and post a comment.

Microsoft Fix it Solution for opening SQL firewall port is Live!

Microsoft Fix it Solution for opening SQL firewall port is Live!

  • Comments 6
  • Likes

clip_image002How do I open the firewall port for SQL Server on Windows Server 2008?

We just released another Fix it Knowledge Base (KB) article. This Fix it addresses the following scenario:

Windows Firewall on Windows Server 2008 helps prevent unauthorized access to computer resources. However, if the firewall is configured incorrectly, attempts to connect to an instance of SQL Server may be blocked. To access an instance of SQL Server that is behind the firewall, you must configure the firewall on the computer that is running SQL Server.

Comments
  • I used fix it on a windows 2008 server it's telling me it does not apply to my system?

  • I used fix it on a windows 2008 server it's telling me it does not apply to my system?

    Me, too

  • The preconditions for the Microsoft Fix simply check to make sure it's server by checking

    Property(C): MsiNTProductType = 3

    And then it checks to make sure SQL is installed on the machine, by checking for this keys and setting SQLSERVER property.  Does this key exist?

    SYSTEM\CurrentControlSet\Services\MSSQLSERVER

    msiexec/i OpenSQLFirewallPort.msi /l voicewarmup /log c:\fixit\fixit.log

    You can get a logfile of the Microsoft Fix it to check the log using the above command to see if the properties are set.

    Thanks,

    John

  • Thanks for sharing your feedback!

  • I cannot update my firewall everything that I need loaded onto my computer requires an 3.5 Firewall so I am not able to load any of HP UPDATES or anything else.  Please help me I do not know what to do.  Also I cannot get my Microsoft mr fixit online to work at all what do I do ?  Please help me

  • my mr fix it center will not load up on my internet so that it can help me fix my problems

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment