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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connection pooling question 4
Severed connections in SQL Server Connection Pool 1
Throttling connections, custom connection pooling 0
ADO.NET Connectionstring+pooling 1
connection status "suspended" 2
Connection Pooling, REVERT & "Connection Reset" in .NET 2.0 SP1+ 0
Why doesn't ADO.Net reuse the connections in the connection pool 2
Connection Pooling With ASP.NET 1.1 3

Back
Top