Machine
Welcome to TechNet Blogs Sign in | Join | Help

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

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.

Published Wednesday, April 22, 2009 10:00 PM by davecal_ms
Filed under: ,

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

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

Tuesday, June 09, 2009 12:06 PM by Daniel

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

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

Wednesday, June 17, 2009 2:27 PM by Joachim Berger

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

Me, too

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

Wednesday, June 17, 2009 5:25 PM by JohnBuk

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

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

Tuesday, June 30, 2009 3:01 AM by MKV to XVID Converter

Thanks for sharing your feedback!

Leave a Comment

(required) 
required 
(required) 

  
Enter Code Here: Required
 
Page view tracker