IIS-ASP-SQLServer connectivity problem

[sm43]

I'm getting pretty wierd behavior from a local web directory of mine. I'm testing a web directory on my laptop that's running Win 2k Pro, iis 5, sql server 2k Personal Edition . My webpages are using ASP (VBScript) to connect to a SQL Server database (I've tried both OLEDB and ODBC-System DSN methods). My webpages are just freezing and not giving back any response. For a reason, this is only happening when a website connects to a SQL Server database, doesn't happen with a website connecting to an Access database..

I don't know if the problem is in IIS, ASP or SQL Server.

And then, this is the most perplexing of things, I change something somewhere and test the page again, and I get an error.

HTTP 403.9 - Access Forbidden: Too many users are connected
Internet Information Services


I know that IIS on Win 2k Pro has a 10 user maximum limit, but I'm only developing & accessing pages on my local computer, how many requests could I be generating? I have the 'HTTP Keep-Alives Enabled' option unchecked. I'm using just one global ADO Connection object in my entire ASP website. I'm thinking that it's something else. At that point, all webpage requests to any website on my local machine, start giving this error, even the IIS help pages.


Does anyone have ideas to the possible cause & solution to this problem?


Thanks.

Saad

 

[Minerve]

You have to re-start the Internet Information Server (service) or to stop and re-start the web site.

What i think you need to do is rebooting the computer if this thing didn't work.

Check your connection string and you can look to :

http://www.asp101.com

little hint that ive just found (not related to you problem but solve some to come:

http://www.sql-server-performance.com/asp_sql_server.asp