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

From: Joe Audette (respondtojoe_audette_at_yahoo.com)
Date: 12/10/03

  • Next message: Thomas H: "Re: Does ASP.Net v.1.1 Forms authentication mode require port 80 for http?" 
    Date: Wed, 10 Dec 2003 14:10:44 -0800

    I would recommend not creating connection strings per
    user because every variation of connection string uses
    more connection pools. I would suggest creating just afew
    connection strings with sql users representing groups
    with the same permissions.

    >-----Original Message-----
    >We have built an ASP.NET application that will run on
    the Intranet using SQL
    >2000 as our data layer. We have decided to use Form
    Authentication coupled
    >with SQL Server Security (due to the fact users will be
    jumping to and from
    >different clients/browsers to work).
    >
    >Our scenario: we are adding users to a SQL 2000 database
    via their company's
    >Windows Active Directory (example, in SQL security tab,
    add new users - find
    >him/her within the domain, etc.). They are stored as a
    Windows User type in
    >the SQL database, not as a Standard SQL user type.
    >
    >The problem I am having is that I cannot open a
    sqlconnection using these
    >usernames and passwords within my ASP.NET logon code.
    >
    >However, I tested it using a Standard SQL user type and
    it worked.
    >
    >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?
    >
    >Thanks guys. Any help/advice would be great!
    >
    >-Todd
    >
    >
    >.
    >

  • Next message: Thomas H: "Re: Does ASP.Net v.1.1 Forms authentication mode require port 80 for http?"

    Relevant Pages

    • Re: Office Web Parts connecting to SQL Server from extranet
      ... and the PivotView parts retrieve data from our SQL Server ... > our extranet, even if the user logs in using their domain credentials, the ... Using connection strings ... > extranet has been to use SQL Authentication and a connection string ...
      (microsoft.public.sharepoint.portalserver.development)
    • Re: Office Web Parts connecting to SQL Server from extranet
      ... and the PivotView parts retrieve data from our SQL Server ... > our extranet, even if the user logs in using their domain credentials, the ... Using connection strings ... > extranet has been to use SQL Authentication and a connection string ...
      (microsoft.public.office.developer.web.components)
    • Re: Office Web Parts connecting to SQL Server from extranet
      ... and the PivotView parts retrieve data from our SQL Server ... > our extranet, even if the user logs in using their domain credentials, the ... Using connection strings ... > extranet has been to use SQL Authentication and a connection string ...
      (microsoft.public.sharepoint.windowsservices)
    • Re: Cant connect to SQL (ASPNET account)
      ... Are you intending to use integrated security or a SQLS login? ... connection strings which are unclear. ... The SQL server is on my webserver running ...
      (microsoft.public.sqlserver.security)
    • ASP.NET Forms Authentication Via A SQL Server Database With Windows User types?
      ... We have built an ASP.NET application that will run on the Intranet using SQL ... They are stored as a Windows User type in ... not as a Standard SQL user type. ... I tested it using a Standard SQL user type and it worked. ...
      (microsoft.public.sqlserver.security)