<div>
Well that kb points to installation of IE9 nothing to do with the firewall<br />
<br />
<a href="http://support.microsoft.com/kb/982861" rel="ugc nofollow">http://support.microsoft.com/kb/982861</a><br />
<br />
IE updates or installs sometimes can cause issues like this. I haven't heard anything about IE9 but I have had issues with IE7
</div>


<div>
Yes, I saw that. &nbsp;I'm reluctant to re-enable the firewall as we are in production and I don't want any interruptions. &nbsp; My big question is why it just started to block SQL, when it had been on and allowing it for years...
</div>


<div>
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
</div>


<div>
I hate to hear that as well. &nbsp;Thats just a silly thing, to have a componant of the OS just bring down a database, arbitrarily...
</div>


<div>
<div class="content wysiwyg-content">
We have a Win 2008 x64 server running SQL 2008 std x64. &nbsp;On Sat morning, we ran windows update. &nbsp;After the server rebooted, none of our applications could contact SQL. &nbsp;The update was KB982861. &nbsp;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. &nbsp;<br />
<br />
Any idea why that update would affect the firewall and cause it to block inbound SQL requests? &nbsp;It's been a operational SQL server for about 2 years now...
</div>
</div>


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...

Why would windows 2008 firewall start to block SQL

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.