mchad65
asked on
Why would windows 2008 firewall start to block SQL
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...
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...
ASKER
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...
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
ASKER
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...
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
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