Slashdot Mirror


10 Years After SQL Slammer

Trailrunner7 writes "Ten years ago today, on Jan. 25, 2003, a new worm took the Internet by storm, infecting thousands of servers running Microsoft's SQL Server software every minute. The worm, which became known as SQL Slammer, eventually became the fastest-spreading worm ever and helped change the way Microsoft approached security and reshaped the way many researchers handled advisories and exploit code. This is the inside story of SQL Slammer, told by David Litchfield, the researcher who found the bug and wrote the exploit code that was later taken by Slammer's authors and used as part of the worm."

7 of 58 comments (clear)

  1. Also decided in favor of restrictive firewalls by xxxJonBoyxxx · · Score: 4, Funny

    Kind of hard to believe that ten years ago it was quite common for people to still have their SQL Servers hooked up the Internet with no firewall or firewall rules that permitted direct connections to the control port. Good luck finding that configuration today...

    1. Re:Also decided in favor of restrictive firewalls by khasim · · Score: 4, Insightful

      I'd love to implement great security for every customer we have but it's always up to them and how much "trouble" they want to get through using their network (even if it isn't really).

      That's the real problem. It will always be easier to NOT do something than it will be to do something.

      And NOT doing something will, 99%+ of the time, will be less expensive than doing something.

      It is only when that less-than-1%-of-the-time event hits that "something" gets done. And even then the 'something" is usually a panic reaction and NOT real security.

  2. HTTP Slammer by rastakid · · Score: 4, Funny

    Slashdot does it again.

  3. Google Cache Version by Anonymous Coward · · Score: 5, Informative
  4. Security priorities have changed by Cid+Highwind · · Score: 4, Insightful

    So this guy "wrote the exploit code that was later taken by Slammer's authors and used as part of the worm", and he's not dead or serving an eleventy hojillion year federal prison sentence?

    Times change indeed...

    --
    0 1 - just my two bits
    1. Re:Security priorities have changed by eap · · Score: 5, Informative

      So this guy "wrote the exploit code that was later taken by Slammer's authors and used as part of the worm", and he's not dead or serving an eleventy hojillion year federal prison sentence?

      Times change indeed...

      The article mentions he was paid by a company in Germany to penetrate their heavily-fortified SQL Server installations. This is when he developed the exploit code. Presumably it's not illegal for a company to pay you to security test its systems.

      He also took the steps of communicating the exploit to Microsoft before releasing the code. He even asked their permission before divulging the code, and didn't do so until MS had released a fully corrective patch.

      You're right, however, he'd be in jail if it happened today.

  5. Our article on the subject: by nweaver · · Score: 4, Informative

    We (David Moore, Vern Paxson, Stefan Savage, Colleen Shannon, Stuart Staniford, and myself) did the analysis of how it spread, including showing how it infected all the vulnerable systems in 10 minutes, and detailing flaws in the random number generator.

    Our article eventually appeared in IEEE Security & Privacy.

    --
    Test your net with Netalyzr