windows authentication & mapping to database

From: Vasu (vasudev_g@hotmail.com)
Date: 11/07/02 

From: vasudev_g@hotmail.com (Vasu)
Date: 7 Nov 2002 14:53:45 -0800

Hi,
We are developing an ASP.Net web app where users log in thru windows
authentication. The app has some preferences and data for each user
stored in sql server 2k.
Which info do I store about the user in the database to uniquely
identify him? As far as i know I could store the domain\loginID or
SID. Could someone tell me which is a better choice or if there are
any other good alternatives to do this. I looked for pointers on MSDN
to do this but could not find anything.
thanks

Relevant Pages

  • Re: Web app on a web server, but run on localhost
    ... You have to know where your web app runs, ... As for the database setup error, it is because you are using SQL Server2005/Express as ASP.NET website's management data store, such as membershipmanagement. ... In this case, the data file used by SQL Server/Express must be on the computer where SQL Server/Express installs, i.e. must be on local drive, not on network location. ...
    (microsoft.public.dotnet.framework.aspnet)
  • DirectoryServices
    ... A system that is being designed will use ActiveDirectory to store ... userinformation for a SQL Server 200 base web app. ... to AD after getting the windwos user account from SQL Server. ...
    (microsoft.public.dotnet.framework)
  • Re: which way to cluster/partition?
    ... > Say you have a web app you want to scale out. ... Option 3 is the very common in production environments requiring high levels ... you can store session state info, and you can also store that info in the DB ... On the backend, many orgs that require HA will cluster their ...
    (microsoft.public.windows.server.clustering)
  • Re: Single sign-on between web & desktop
    ... web app, starting with something like ASP.NET forms authentication is ... Joe Kaplan-MS MVP Directory Services Programming ... "User credentials come from a Windows domain" should be "User ...
    (microsoft.public.dotnet.security)
  • Re: 401 Access Denied while accessing WSE 3.0 WebService
    ... I also tried impersonating an account ... web app. ... > what kind of authentication you have turned on in IIS? ... > the ASPNET user access to the WS and all dependant resources thereof? ...
    (microsoft.public.dotnet.framework.webservices.enhancements)