Network Traffic caused by SQL Server 2000 ?

I have an urgent question?..Last week I installed SQL Server 2000 in a Windows 2000 server. I started to have problems with my internet connection, it was down every hour. I checked my network with a tool and I discovered that my bandwidth had excessive network traffic, besides that, the internet was very slow.

I am sure that the SQL Server installation caused that, but I don't know why?

I stopped the SQL Services and everything was normal after that.

I need to restart SQL again, but I don't know what to configure to stop the network collisions and the traffic?

Can somebody help me?

Is it true that I have to deactivate Named Pipes protocol?

Thanks in advance!!!

modezaAsked:
Who is Participating?
 
arbertCommented:
Agree with the above--make sure you have SP3a installed (first SP that protects you from slammer) and do a thorough virus scan...
0
 
billy21Commented:
There are a lot of viruses that specifically target SQL Server.  If the sql server is open to the outside world you may be infected.  SQL server should be kept safely behind a firewall at all times.
0
 
AaronAbendCommented:
This sounds like Slammer. Have you downloaded the patch? Also, change your SA password. If SA password is blank, you are susceptible to slammer infection.
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
AaronAbendCommented:
http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=WORM_SQLP1434.A

Here is one of many links that will help you get rid of slammer
0
 
modezaAuthor Commented:
Thanks a lot!!!!!..I already downloaded service pack 3, and I will see if that helps..If I'm still have the problem I will let you know!!!
Thanks for your support!
0
 
modezaAuthor Commented:
I uploaded SQL server since yesterday with the service pack 3 and it is working fine....Thank all for your help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.