Peter, This was very useful and insightful feedback! Thanks for the tip.
On Wed, 10 Apr 2002 14:02:16 -0700, Peter Stephens <peter- [EMAIL PROTECTED]> wrote: >> Teo Lachev spake: >> >> That's what I thought but I see more and more MS examples that advocates >> the use of integrated security so I thought it will be a good idea ot >> check. >> >> Peter, >> >> Is there any way (besides testing it) to confirm this behavior - a link to >> documentation, book, etc. that you know of? > >I do not recall precisely where I found that Integrated security requires >the same domain user to enable connection pooling. I believe I discovered >this behavior by reading various newsgroups, but I cannot remember which >one. I too was planning on using integrated security under the assumption >that Connection Pooling would still work. It would make sense if the .NET >documentation was a little more clear in this area. > >I just did a quick look using Anakrino[1] and found that if integrated >security is enabled then the hash value for the connection pool is >ConnectionString + WindowsIdentity.GetCurrent().Name otherwise just the >ConnectionString is used. You can verify this behavior by looking at the >ILDASM for SqlConnectionPoolManager.GetPooledConnection(...) > >-- >Peter > >[1] http://www.saurik.com/net/exemplar/ > >You can read messages from the DOTNET archive, unsubscribe from DOTNET, or >subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the DOTNET archive, unsubscribe from DOTNET, or subscribe to other DevelopMentor lists at http://discuss.develop.com.
