Re: ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?

From: Todd (tsloan_at_smithdata.net)
Date: 12/11/03 

Date: Thu, 11 Dec 2003 15:18:21 -0500

Thanks Mike.

Yeah, we have decided to go with SQL Server security vs Windows (using
Standard SQL Users, not the Windows Users) - it just seems to be the ideal
authentication protocol with what we are trying to scope.

-Todd

"Mike Kruchten" <mkruchten@fsisolutions.com> wrote in message
news:OEEwqvAwDHA.1424@tk2msftngp13.phx.gbl...
> > Is it possible to use ASP.NET Forms authentication via a SQL Server
> database
> > with Windows User types? Or is it only possible to use this method using
> SQL
> > Standard user types?
> >
> No. The Windows user type in SQL Server uses the security context of the
> users connection, not a username and password.
>
> Mike
>
>

Relevant Pages

  • AUTHENTICATION TO APPLY SP3
    ... a problem with SP3? ... > SQL Server 2000 RTM Standard Edition ... >windows user. ... >These accounts and passwords are good because I can get ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2008 set up
    ... Probably you did not install your SQL Server 2008 Instance under this Windows User Account and probably you did not add this user to the "SQL Server System Administrators" list during SQL Server 2008 Setup. ...
    (microsoft.public.sqlserver.setup)
  • Copy User permission
    ... We are migrating Windows user to amnother domain, ... server windows users have sid, and name hard coded to the ... SQL Server ... login id to a new login id? ...
    (microsoft.public.sqlserver.security)
  • Re: Get Login
    ... In "Windows Authentication mode" the system_user returns the ... Sql Server can't know the Windows User name if the Authentication is "SQL ... Prev by Date: ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Using a specific user as PublisherLogin
    ... This is based upon whether your replication SecurityType is set to ... Windows User on the machine or has DB privileges on the SQL server. ... NTAuthentication settings are the easiest to setup for users who have ...
    (microsoft.public.sqlserver.ce)