SQL-websites working on/off

I'm running a webserver with MS Win2000 Advanced Server w/ SP4, SQL Server 7.0 and IIS 5.0. Have downloaded and installed all available Windows Updates. Both IIS and SQL Server 7.0 are running on the same server. I have tried to install the SP4 for the SQL Server, but a script-error occured during the installation, which led to that I'm still using the standard no-service-pack installation. The websites using perl / odbc / sql databases are responding on and off in intervals of 10-25 seconds. Websites using just regular html files or perl-scripts without any sql-databases involved, are working just fine all the time (also when the SQL-based websites are "pausing"). The same problem occurs with both SQL Server databases and Access (.mdb) databases. The only thing I can see that they have in common is ODBC...?

The same problem actually also occurs when using the SQL Server Enterprise Manager, when clicking the SQL Server registration. If doing so in a "off-period", it results in an error message saying "timeout expired".

The webserver has been up and running for a couple of years without this kind of problem before. I have the feeling that the problem started around the same time that one or more of the Windows Updates were installed... maybe some kind of conflict with exisiting SQL / ODBC drivers and the installed updates...?

There are no viruses, worms etc. on the computer as far as I can understand.
Would really, really appreciate all the help I can get on this matter...

Seems to be related to SQL Server, and not IIS, try:

microsoft.public.sqlserver.server

--
Regards,
Kristofer Gafvert - IIS MVP
<a style='text-decoration: underline;' href="http://www.ilopia.com" target="_blank">http://www.ilopia.com</a> - When you need help!


"Finn" <finnharald.TakeThisOut@yahoo.no> wrote in message
news:399586C7-BD8D-4081-BBCA-E4A7FC702413@microsoft.com...
 > I'm running a webserver with MS Win2000 Advanced Server w/ SP4, SQL Server
7.0 and IIS 5.0. Have downloaded and installed all available Windows
Updates. Both IIS and SQL Server 7.0 are running on the same server. I have
tried to install the SP4 for the SQL Server, but a script-error occured
during the installation, which led to that I'm still using the standard
no-service-pack installation. The websites using perl / odbc / sql databases
are responding on and off in intervals of 10-25 seconds. Websites using just
regular html files or perl-scripts without any sql-databases involved, are
working just fine all the time (also when the SQL-based websites are
"pausing"). The same problem occurs with both SQL Server databases and
Access (.mdb) databases. The only thing I can see that they have in common
is ODBC...?
 >
 > The same problem actually also occurs when using the SQL Server Enterprise
Manager, when clicking the SQL Server registration. If doing so in a
"off-period", it results in an error message saying "timeout expired".
 >
 > The webserver has been up and running for a couple of years without this
kind of problem before. I have the feeling that the problem started around
the same time that one or more of the Windows Updates were installed...
maybe some kind of conflict with exisiting SQL / ODBC drivers and the
installed updates...?
 >
 > There are no viruses, worms etc. on the computer as far as I can
understand.
 > Would really, really appreciate all the help I can get on this matter...

 >
 ><!-- ~MESSAGE_AFTER~ -->