Speed of SQL Authenication vs. Trusted Connection
- From: 2redline@xxxxxxxxx
- Date: 24 Apr 2006 08:49:25 -0700
Why would SQL Authenication be slower than Trusted Connection?
Could the person who coded it done somthing to prefer trusted and when
it fails to use sql authenication and thus slow it down.
The same front-end using sql authenication is 1/20th the speed of when
it is switched to Trusted connection.
We do not use domain servers since we use Novell for network storage so
we really want to find out why sql authenication is so slow as it will
not work with 60+gig db of database.
Thanks
.
- Follow-Ups:
- Re: Speed of SQL Authenication vs. Trusted Connection
- From: 2redline
- Re: Speed of SQL Authenication vs. Trusted Connection
- Prev by Date: Assigning Permissions to a Database
- Next by Date: Re: public role question
- Previous by thread: Assigning Permissions to a Database
- Next by thread: Re: Speed of SQL Authenication vs. Trusted Connection
- Index(es):