The web server uses some SQL credentials to connect to the SQL Server. So, if you have such a hardwired user for your SQL connection, that one will be repeatedly setting the connections. Usually you'll get a connection, perform the query and leave the SQL Server.