SQL Server Authentication versus Windows Authentication

microsoft.public.dotnet.framework.adonet

13 Jul 2006 9:13 PM

supvine

Hello,

I am hearing conflicting point of views regarding ASP.Net development -
some folks say that when connecting to a SQL Server via ASP.Net it is
better to connect using Integrated Windows Authentication (trusted
connection) while others say that it is better to connect using SQL
Server Authentication.

The two modes mean the following to me -

Windows Authentication Mode - meaning a domain account given permission
to a particular SQL Server database.

SQL Server Authentication Mode - meaning an user created in SQL Server
itself and given specific permissions to a database.

Could someone provide me with some direction regarding these two
options and what are the advantages and disadvantages of each of these?

Thanks for your help regarding this.