Re: Why Windows Authentication?

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 03/30/05 

Date: Wed, 30 Mar 2005 08:20:34 -0600

To add to the other responses, you can use application roles regardless of
the authentication method. 

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"Jason Mauss" <jason.mauss@nospamgmail.com> wrote in message 
news:OgSST3INFHA.1948@TK2MSFTNGP14.phx.gbl...
> Most of the security-related things I read about SQL Server says you 
> should
> run Windows Authentication only. Why is that?
>
> If you run Windows Authentication only, does that stop you from 
> implementing
> application roles and stuff like that?
>
>

Relevant Pages

  • Re: NT authentication vs. SQL auth
    ... that Windows Authentication is more "demanding" than is SQL Server ... I would think that SQL Server, rather than just looking at its own (probably ...
    (microsoft.public.sqlserver.security)
  • Re: NT authentication vs. SQL auth
    ... that Windows Authentication is more "demanding" than is SQL Server ... I would think that SQL Server, rather than just looking at its own (probably ...
    (microsoft.public.sqlserver.security)
  • Re: SBS 2000 + ASP.NET 1.1 + IIS Lockdown not working.
    ... Currently I am using Windows authentication. ... I will try SQL Server ... You can encrypt these string ...
    (microsoft.public.inetserver.iis.security)
  • Re: Need Help w/ SQLServer Express Authentication
    ... Windows Authentication can not be disabled using Mixed Authentication. ... You can only disable SQL Server authentication and Microsoft recommends using Windows Authentication when possible. ... Logins make your users to connect and perform their tasks in SQL Server. ...
    (microsoft.public.sqlserver.setup)
  • Windows Authentication with SQL Server running on Workgroup server machine
    ... I'm currently trying to understand SQL Server Windows Authentication ... The server is a machine named 'databaseserver' that runs SQL Server ...
    (microsoft.public.sqlserver.connect)