sql server connect: Why Windows authentication slow? -- sql server connect

Why Windows authentication slow?

Srinivasulu
7/22/2003 7:38:03 PM

sql server connect: Dear All,
In my VC++ program I am trying to connect to SQL Server
2000 using ADODB. When I am using windows authentication (
ie strConnection = "Driver={SQL
Server};Server=MyServerName;Database=MyDatabaseName;Trusted
_Connection=yes;" ) it is very slow( Approx 60 %less)
when compared to DB authentication ( ie strConnection
= "Driver={SQL
Server};Server=MyServerName;Trusted_Connection=no;Database=
MyDatabaseName;Uid=MyUserName;Pwd=MyPassword;" ).

Can anyone help me in this regard. Thanks in advance.
Thanks & Regards
Srinu

Re: Why Windows authentication slow?

Kevin
7/23/2003 1:36:30 PM

Can you define slower? In our systems, windows auth is about 30% slower,
but we are talking about a difference between 15ms and 20ms, most of which
is mitigated with connection pooling in the larger systems anyway.

--
----------------------------------------------------
The views expressed here are my own
and not of my employer.
----------------------------------------------------
[quoted text, click to view]