March 17, 2003 at 3:46 pm
I have a ADSL with static IP and internet was freezing up on me after a while. I figured out that whenever SQLServer 2000 service starts this happens (when SQL2000 service is off, it works fine). When the internet hangs, it says 'connecting to website .. waiting for reply' but nothing happens.
I upgraded W2000 server from SP2 to SP3, and fixed the memory from dynamic to fixed (300MB of the 1G) but to no avail.
This is really messing up my projects. Any suggestions would be most welcome.
March 18, 2003 at 1:58 am
Have you patched for Slammer (or using SP3)? It could be that your SQL Server instance gets hit by Slammer and then clogs up your internet connection.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 18, 2003 at 7:33 am
Yes, I updated to SP3. I think that is sufficient. Actually, sometimes the internet connection works for a while, and then if not used for a couple of hours, hangs up.
Is there some other way to check/fix the slammer worm's existence?
March 18, 2003 at 7:37 am
What happens when you change the port your SQL Server is listening to to some large number like 7777 or 8888 or 9999? Does it still lockup your internet connection?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
March 18, 2003 at 7:57 am
How do I change the port (and find out what it currently is)? I'll try anything
March 18, 2003 at 8:13 am
Server Network Utility. You'll see it in the same folder as SQL Server under Start | Programs. It'll require you to stop and restart SQL Server. I'm wondering if there is a port conflict. The likelihood is extremely small, but needs to be ruled out.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
March 18, 2003 at 1:25 pm
I changed the TCP/IP port from 1433 to 8888 but the IE still hangs up and does not connect
March 18, 2003 at 1:42 pm
OK, that eliminates the port as a possibility. Does the modem manufacturer say there's any conflict with any services such as SQL Server?
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
March 18, 2003 at 3:55 pm
Hey there,
You mention you have ADSL.
Does your provider use PPPOE?
If so, then your connection might be closing out every so often.
PPPOE disconnects after a while requiring you to re-connect the next time you want to use the net.
Just a suggestion yo may want to check out.
Mark
March 19, 2003 at 12:25 am
The ISP that gave the modem has several people using it (100's) and they have no problem. Many use SQL server. They too are baffled.
The ADSL works fine without the SQL service for days, until I turn the SQL service. Then I use it for an hour or so, come back after an hour or so and use for 15 minutes .. repeat after an hour or so for 15 minutes .. and then it may die out overnite - but it always dies out when SQL service is turned on - usually after a period of not using the internet.
March 24, 2003 at 1:24 pm
It looks like this might be confusion over SQL Server 2000 SP3 versus Windows 2000 SP3.
Do you have SQL Server 2000 SP3 installed?
In the first message in this thread, you indicate that you upgraded Windows 2000 from SP2 to SP3. In response to the question "Have you patched for Slammer (or using SP3)? ", you indicate state "Yes, I updated to SP3."
You can get tools to check for Slammer vulnerability and/or get SQL Server 2000 SP3 at http://www.microsoft.com/sql/default.asp.
Regards,
Mike
March 24, 2003 at 8:30 pm
I downloaded the security tools and ran them and it fixed the problem.
March 25, 2003 at 1:33 am
quote:
I downloaded the security tools and ran them and it fixed the problem.
I would advice downloading and installing SQL Server 2000 Service Pack 3 as well, even if you've patched the spcedific security hole for Slammer.
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
March 25, 2003 at 11:54 am
I was going to put SQLServer SP3 but the download screen advised I make a backup of the data. I have a 40GB database which I can only put on my 120GB external harddisk. Rather then make a backup (and perhaps not be able to restore it properly), I did what I have done before (when I had a network of 2 computers) - I created an instance on the external harddisk, and a database with the same name. Then I went through the Export Wizard and tried to copy all the objects for the database (that way I can query the new copy and make sure it works). However it was extremely slow and after about 8 hours (and 4GB transferred ..) it came up with the message saying the Primary Filegroup was full. At this point I abandoned the backup.
Do you know how I can get past this message
March 25, 2003 at 12:28 pm
Why don't you just make a full backup of the database on instance A, then try to restore it to instance B. If this works then you know the backup is OK. Why shouldn't you be able to restore properly?
--
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 15 posts - 1 through 15 (of 20 total)
You must be logged in to reply to this topic. Login to reply