Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 sql server attack!!! urgent please help!!!!!!!!!!!

Author  Topic 

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2003-01-25 : 10:04:08
hi,
Is any one aware of the recent attack on the sql server?
my server is attaked by it but we are unable to find a fix to it.
it eats all the bandwidth and no one on the network is able to access the internet and the server.the server cpu shows 100% cpu.

i have sql server 2k on win2k advanced server.

any ideas?
please help and its urgent!!!!!!

harshal.

Expect the UnExpected

ncrosby
Starting Member

8 Posts

Posted - 2003-01-25 : 10:22:53
You'll want to apply SP3 and stay up-to-date on all security patches. It can be easy to look these over until something like this hits home.

http://www.sqlteam.com/FilterTopics.asp?TopicID=126

Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2003-01-25 : 10:37:28
You should also configure your firewall to block any incoming UDP traffic on port 1434, especially if the server can be accessed from the internet.

Go to Top of Page

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-01-25 : 12:07:31
The specific patch for this exploit (and others) was released over 7 months ago in July 2002. Now I know it's a PITA currently to apply the cumulative security hotfixes because it's a manual process (although it can be easily automated with a bat file or vbs script) but that's no real excuse for not keeping servers up to date with security hotfixes.


HTH
Jasper Smith
Go to Top of Page

Argyle
Yak Posting Veteran

53 Posts

Posted - 2003-01-27 : 19:05:08
It's nice to see that Microsoft now has released a SQL hotfix installer.

INF: SQL Server Hotfix Installer
http://support.microsoft.com/default.aspx?scid=kb;EN-US;330391

First patch using it (that I know of) is the re-release of the latest patch the 26th January:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333&sd=tech

/Argyle

Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-01-27 : 19:10:33
I'm surprised that servers were affected by this. It has been known for quite some time that 1434 was vulnerable. I saw an article today that says some major corporations (BofA for instance) were affected by this. I wonder if some of their IT staff got the boot today because of this.

Go to Top of Page

harshal_in
Aged Yak Warrior

633 Posts

Posted - 2003-01-27 : 23:56:28
actually a day bfore I had shifted my server to a new box and installed the sp 2 and before going for sp3 the machine was infected.
n ways I have installed sp3 now .
but the worm had caused considerable probs here in india the isp's were out of order for almost whole day.some of the atms were shut off.

Expect the UnExpected
Go to Top of Page

shsmonteiro
Constraint Violating Yak Guru

290 Posts

Posted - 2003-01-28 : 01:17:44
I've got a question on this vulnerability and the MS02-061 patch and so on...
According to the original Bulletin, the vulnerability was introduced by the multiple instances feature in SQL 2K. Well, it means that if you don't use named instance you're not affected, isn't... In fact, on all server that do not use NI, the 1434 port is no shown in a netstat command output.

Go to Top of Page

Argyle
Yak Posting Veteran

53 Posts

Posted - 2003-01-28 : 10:41:20
Even if you do not use named instances your server still listen on port 1434 and you risk getting infected if you are not patched.

When you run netstat you will see the names "ms-sql-s" and "ms-sql-m". If you (on windows 2000) go to c:\winnt\system32\drivers\etc\ and open the file named "services" you will see what ports these names actually mean.

There will be something like this:
ms-sql-s 1433/tcp #Microsoft-SQL-Server
ms-sql-s 1433/udp #Microsoft-SQL-Server
ms-sql-m 1434/tcp #Microsoft-SQL-Monitor
ms-sql-m 1434/udp #Microsoft-SQL-Monitor

/Argyle

Edited by - argyle on 01/28/2003 10:43:24
Go to Top of Page
   

- Advertisement -