Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  IIS draws multiple connections on 1433

Author  Topic  garyb Starting Member 1 Post Posted - 2007-01-15 : 05:21:06 I have SQL2000 with 8 databases running on the LAN. In our DMZ we have a web server [IIS5] which connects to the SQL on 1433 through the DMZ/LAN port. Up until last Tuesday everything seemed OK with approx 10 connections form DMZ>>LAN on port 1433 whenever the site was opened. However now I am seeing 50-60 connections even though there are only a max of 10 users connected. As a test I closed the website to the WAN [0 connections] and opened one occurrence of the website . It immediately, created 2 IIS connections and 10 SQL connections. After 20-30 seconds the SQL dropped to 2 connections until I clicked an internal link, & then it rose back to 10 again. Does this make sense, I dont know what the developers may have done to trigger this and not sure where to go next. Connection pooling is enabled & we use DSNs to make the IIS>>>SQL connections. Thanx for your time G