Why use Win Authentication instead of SQL

From: Otis Bricker (obricker_at_my-dejanews.com)
Date: 11/11/05 

Date: Thu, 10 Nov 2005 16:07:13 -0800

Could anyone point me towards a document that itemizes the security
advantages of using Windows Authentication rather than SQL Server logins?
Preferably something from MS directly.

I need some ammo to deal with a request that we stop using Windows in favor
of logins. As if the ability to control and change passwords in one place
wasn't enough.

Thanks.

Otis B.

Relevant Pages

  • RE: Login Failure to Frontpage Admin
    ... compromise security to my websites and my server as the follwing procedure ... did popup a security message. ... My websites by default were ALL set to "Integrated Windows Authentication" ...
    (microsoft.public.frontpage.extensions.windowsnt)
  • security works for VPN users, doesnt for local
    ... i am attempting to configure security for an intranet web application ... it uses Windows authentication, retrieving roles from ... "Directory Security" tab in IIS i have: ... unchecked "Enable anonymous access" ...
    (microsoft.public.dotnet.framework.aspnet)
  • IIS6.0 use anonymous and integrated security a the same time
    ... I set up a IIS 6.0 sever a while ago when we were young and innocent and decided to implement a few simple security baseline for the intranet web site: ... The problem is we don't share an active directory or any NT domain relationship at all, so I need to activate the anonymous access on the web site and if I do that, I cannot use the windows authentication anymore... ... continue using the IIS/NTFS authentication for my domain users OR still get the security information with the anonymous acces activated. ...
    (microsoft.public.inetserver.iis.security)
  • Re: security works for VPN users, doesnt for local
    ... What machine is the VPN machine? ... The web server by chance? ... it uses Windows authentication, retrieving roles from ... "Directory Security" tab in IIS i have: ...
    (microsoft.public.dotnet.framework.aspnet)
  • IIS & SQL Issues
    ... impersonation to run a page that accesses SQL Server via integrated ... I've set IIS security to ... integrated Windows authentication. ...
    (microsoft.public.dotnet.framework.aspnet)