Connection Pooling

  • Thread starter Thread starter RickT
  • Start date Start date
R

RickT

How does using .NET Connection Pooling with Trusted Connections work inside
SQL2K? Can the server use the same connection for 2 different users, or
does each user get their own connection?

- Rick
 
Hi Rick,
in order to use the benefit of connection pooling you should access Sql
Server with the same credentials.
If you have 2 different users you will have 2 different connections unless
you have one Sql Server login for both of them.

Best regards

Ryszard Gawron
Microsoft Developer Support
 
Are you sure? I thought any that had the same connectionString would be
able to use connections from the same pool? If you use Windows
Authentication instead of SQL authentication, then everyone will have the
same connection string, thus pulling from the same pool?
 
Back
Top