Why would windows 2008 firewall start to block SQL

mchad65
mchad65 used Ask the Experts™
on
We have a Win 2008 x64 server running SQL 2008 std x64.  On Sat morning, we ran windows update.  After the server rebooted, none of our applications could contact SQL.  The update was KB982861.  Once I got the call this morning from our UK office, that the server was not responding, turning off the firewall restored connectivity to everything.  

Any idea why that update would affect the firewall and cause it to block inbound SQL requests?  It's been a operational SQL server for about 2 years now...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2012

Commented:
Well that kb points to installation of IE9 nothing to do with the firewall

http://support.microsoft.com/kb/982861

IE updates or installs sometimes can cause issues like this. I haven't heard anything about IE9 but I have had issues with IE7

Author

Commented:
Yes, I saw that.  I'm reluctant to re-enable the firewall as we are in production and I don't want any interruptions.   My big question is why it just started to block SQL, when it had been on and allowing it for years...
Top Expert 2012

Commented:
Well I hate to say this but Windows Firewall seems like it does it own thing sometimes or something that wasn't configured before all of sudden it decides to not to allow a service in that wasn't configured

Author

Commented:
I hate to hear that as well.  Thats just a silly thing, to have a componant of the OS just bring down a database, arbitrarily...
Top Expert 2012
Commented:
Yeah I agree but there agrument is to have the firewall fully configured even if it works without being configured you should add the data into the firewall configuration.

Now that said I have even had issues with the firewall when configured but not as much.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial