| I've configured SQL Server 7 to use the encrypted Multiprotocols library. I've also configured an IIS Web server to connect using Multiprotocol encryption. When a client is querying a DB on SQL server thru the website, a TCP/IP connections is open between the IIS Web server and the SQL server. Once the client disconnect, the TCP/IP connection is left open. The connection remain open until I stop the SQL Server Service. I've also, tried setting the connection time-out in IIS to 30 seconds and disabled the "HTTP Keep Alive" setting, which had no effect on the SQL connections. What other application is managing the client connection beside IIS? Is there a timeout setting for Multiprotocols in SQL Server 7? |