Sunday, March 25, 2012

Connection pooling and Windows authentication

Hello:
I am correct that if I use Windows authentication on SQL2000 I will loose
connection pooling ?
Thanks
Terry
Not exactly; connections will not be pooled between accounts, but I believe
that if two connections are made with the exact same security credentials,
pooling will work.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Support" <RemoveThis_Support@.mail.oci.state.ga.us> wrote in message
news:%23qgxFtKzEHA.2788@.TK2MSFTNGP15.phx.gbl...
> Hello:
> I am correct that if I use Windows authentication on SQL2000 I will loose
> connection pooling ?
> Thanks
> Terry
>

No comments:

Post a Comment