Re: Connection Best Practice

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: William \(Bill\) Vaughn (billvaRemoveThis_at_nwlink.com)
Date: 06/09/04 

Date: Tue, 8 Jun 2004 20:28:09 -0700

Windows Authentication is better in most situations. The MSDN site is full
of whitepapers that describe why. 

-- 
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"Alex" <anonymous@discussions.microsoft.com> wrote in message
news:09DA834A-A7B1-40AC-ADD6-E4B1EE9D54E5@microsoft.com...
> I have a middle tier dll that will be accessing SQL Server 2000 with ADO
.NET. What is the best way to do my connection? Adding a user to SQL Server
or using the Windows authentication?

Relevant Pages

  • Re: Catalog of tables in an SSCE database
    ... William Vaughn ... Microsoft MVP ... Please reply only to the newsgroup so that others can benefit. ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Replacing tables in SQL EXPRESS
    ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Replacing tables in SQL EXPRESS
    ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... "William Vaughn" wrote: ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Join Two datasets
    ... William (Bill) Vaughn ... Microsoft MVP ... JOIN on the SQL Server when you fetch the data. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Randomly get timeout on SqlClient hitting localhost
    ... the SQL Server debugger STOPS the service when you hit the breakpoint... ... Microsoft MVP ... "William (Bill) Vaughn" wrote: ...
    (microsoft.public.dotnet.framework.adonet)