ASP.NET and SQLClient Connection pooling
I should know this I suppose....
If you set up an ASP.NET application with the following entries in web.config:
<authentication mode="Windows" />
<identity impersonate ="true"/>
And in the application, you create SqlConnection objects based on using a Trusted Connection:
SqlConnection conn = new SqlConnection();
conn.ConnectionString = "Integrated Security=SSPI;Initial Catalog=northwind;<....>";
conn.Open();
If you have 500 users using the ASP.NET application, do you have 1 connection pool or 500?