Slow script execution on IIS 6

hello everyone, recently we've just bought a new server and installed Win 2003 on it. I have developed my web apps on classic ASP and used IIS 5 for them and everything was just perfect, but now that i moved them to IIS 6 I've noticed that scripts that executes store procedures (the ones that fetch hundreds of rows) are pretty slow. Sometimes i get Internal Server Error 500, some others after several minutes got executed but with errors involving connection closed or cant open table.
I've been reading Microsoft IIS 6 documentation and found nothing there that could help. I think i have configured IIS 6 on the right way cause others of my ASP apps works fine.

Does anyone know any related issues executing classic ASP in IIS6?? o something that could help?

I'd really appreciate your advice to help me work out this problem.

Thanks!

whats are u using as ur DB?

is the db on the webserver?

I'm using SQL Server 7 running in a different server. But i don't think the DB could be the problem since i've already changed the DB to MSSQL 2000 and had the same problem. so there's something about the webserver that i just dont know how to work around it.

Thanks for your reply.

i was just checking ur not using MS access or SQL server on the same server.

did you use the Microsoft IIS 6.0 Migration Tool to transfer from the old web server?

I'd be looking into network configuration issues and/or firewall settings. Incorrect DNS settings can cause slowdown problems, for example.

ok to sort this issue out open the IIS MMC expand the web server name right click web sites and select properties then click the service tab tick run www service in IIS 5.0 isolation mode.

this will improve ur classic asp pages run time.