Membership - "Mixed" Windows & SQL Server authentication?

Hi All,

I'm thinking about using membership and role management features in order to control the access to a system we are creating. This system will have some functionalities accessed through internet and some funcionalities from within intranet (internal staff shall have different roles from external users and therefore).

Is it possible to use Windows authentication for internal users and SQL Server to authenticate external users Can I use the default providers to do this or I need to develop this provider

Thanks a lot!

Sergio




Answer this question

Membership - "Mixed" Windows & SQL Server authentication?

  • remedios_

    Hi Charles,

    I've already tested the SQL Server membership and it works fine, what I'd like to do is authenticate the user against Windows user/password and if it does not pass try SQL Server authentication. We are creating a system that is partially on a intranet and partially (some features) available for external users so I'd like to do a unique treatment for both scenarios (without making every internal user create a new user/password on SQL Server , what means another password they need to remind ). Is there any membership provider I can use for this or I need to programatically implement this (maybe wrapping both SQL Provider and Windows Authentication Provider on a customized provider)

    Thanks,


    Sergio



  • yvolk

    Hi,

    You should look into the System.Web.Security namespace and use the Sql Server membership and role providers.

    Here are some tutorial:

    http://www.odetocode.com/Articles/427.aspx

    http://www.odetocode.com/Articles/428.aspx

    Charles


  • ReneeC

    I believe that you have to build it yourself.

    Fortunalety the whole system is very extensible. Search in msdn for the full details. Here's a tutorial:

    http://www.devx.com/asp/Article/29256

    Charles


  • Membership - "Mixed" Windows & SQL Server authentication?