title: Sql server and Asp.net closing connection does not close the Sql Server Session
body: <p>I'm using an Asp.NET Web Application with MSSQL Server.
  In my page i open a connection and i close it at the end of page.
  But in Sql Analyzer the Sql session is still there, giving me after some amount of time a connection pool limits exceed error.
  Sessions are cleared only when i shutdown the webserver.</p>
  
  <p>Can someone explain how to fix this?
  Thanks</p>
  
  <p>This is the code i'm using:</p>
  
  <pre><code>Conn = new SqlConnection(StrConn);
  Conn.Open();
  
  .....
  
  Conn.Close(); // In the debugger i can see connection state = closed
  Conn = null;
  </code></pre>