October 28, 2002 at 2:22 pm
We moved to a new server and loaded SQL Serever 2000 along with IIS. We have discovered that if we have more than 54 IP addresses active, we can not restart SQL Server. Drop under 55 and no problem. So far no one has been able to figure this out.
Does anyone have any suggestions?
Orin R. Wells
Kent, WA
Orin R. Wells
Kent, WA
October 28, 2002 at 6:08 pm
Not generally a good idea to run on the same server. Still, thats an interesting problem. Do you get anything in the event log? SQL error log?
Andy
October 29, 2002 at 11:09 am
Yes, what we see in the log is just after the line containing the "using 'sqlimage.dll' version '4.0.5'we get a stack dump message and all the joys that follow.
Unfortunately, I have no clue how to use this to help diagnose the problem. Is there some setting in SQL Server 2000 that has anything to do with IP addresses? Just by adding this 55th IP address causes this to happen. It appears it can be ANY ip address.
And, yes We know it would be nice to be able to afford a separate machine to run the SQL and one day we may be able to justify it. But we are a small operation that has to count the pennies.
Orin R. Wells
Kent, WA
Orin R. Wells
Kent, WA
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply