Authenication Mode

I've been reading on the authentication modes - Windows and mixed (sql
server). I'd like some comments on the pros and cons of each and which
most people use.
As I understand it with Windows your windows login is used to get you into
the SQL server. What happens after that - do you still need to assign
users to the database?
Thanks.
--
Brett I. Holcomb
brettholcomb@.R777bellsouth.net
Remove R777 to emailHi,
Yes. Login will just allows you to authenticate to SQL Server. After that
you will have associate the login with a database user and
assign permission for that database user to access each of the required
databases.
Thanks
Hari
SQL Server MVP
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email|||Brett I.Holcomb
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --security
best practices
"Brett I. Holcomb" <brettholcomb@.bellsouth.net> wrote in message
news:%23yDEYNu1GHA.1256@.TK2MSFTNGP02.phx.gbl...
> I've been reading on the authentication modes - Windows and mixed (sql
> server). I'd like some comments on the pros and cons of each and which
> most people use.
> As I understand it with Windows your windows login is used to get you into
> the SQL server. What happens after that - do you still need to assign
> users to the database?
> Thanks.
> --
> Brett I. Holcomb
> brettholcomb@.R777bellsouth.net
> Remove R777 to email