 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / General / Security / April 2006Speed of SQL Authenication vs. Trusted Connection
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 Just wanted to post our findings here to maybe help others. It was an issue with the Access front-end. Created a new mdb, file, import, select all, select all, ...... and them re-linked references etc. Now sql authenication is as fast as trusted connection. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.