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.
I used fix it on a windows 2008 server it's telling me it does not apply to my system?
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?
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 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