This FUCKING SQLSlammer keeps getting me
 

Anyone know how to keep it out for good?

My firewall keeps shutting down whenever it hits. I'm using McAfee.

what is it excatly?

Sounds like a shitty firewall. Just close that port. It's the port that SQL Server communicates on... I think at least one of 'em is 1733. Or just ignore it. It can't hurt you if you have SQL Server updated and secured, or if you don't have SQL Server at all.

I don't know how to close any ports....there does'nt seem to be an option for that on my firewall.

SQLSlammer is the bug that hit the net about a month ago, it was on the news and shit.

Any suggestions for better firewalls?

Just run the latest win2k updates and sql server updates.
That is good enough.

Or get a real firewall, can recomend Cisco.
For a software firewall use Sygate firewall that keeps it out as well.
www.sygate.com

Here's how to fix it. You need to patch SQL Server with the patch published, or better yet, install Service Pack 3. The problem is that the the patch requires Service Pack 2 and if you haven't installed SP2, the patch will not work and SQL won't see your data. The bigger problem is that installing SP2 will start SQL server and the slammer will kick in before the install completes.

So the only fix is for your host to install SP2 and SP3 with the network cable unplugged on your box. Then you're fine.

Thanks, Lens