Freigeben über

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

  • Artikel

clip_image002 How 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

  • Anonymous
    January 01, 2003
    Thanks for sharing your feedback!

  • Anonymous
    January 01, 2003
    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? SYSTEMCurrentControlSetServicesMSSQLSERVER msiexec/i OpenSQLFirewallPort.msi /l voicewarmup /log c:fixitfixit.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

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

  • Anonymous
    June 17, 2009
    I used fix it on a windows 2008 server it's telling me it does not apply to my system? Me, too

  • Anonymous
    June 14, 2012
    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

  • Anonymous
    June 14, 2012
    my mr fix it center will not load up on my internet so that it can help me fix my problems