Re: windows authentication & mapping to database

From: Mary Chipman (mchip@nomail.please)
Date: 11/08/02 

From: Mary Chipman <mchip@nomail.please>
Date: Fri, 08 Nov 2002 09:43:06 -0500

Assuming you're going to create a primary key or unique index on the
resulting column in the SQL Server table, then you should pick the
narrowest (smallest) possible value that will deliver uniqueness. If
you're connecting to SQLS using the ASPNET account, the Windows
identity information won't be available unless you pass it explicitly
as parameters.

-- Mary
MCW Technologies
http://www.mcwtech.com

On 7 Nov 2002 14:53:45 -0800, vasudev_g@hotmail.com (Vasu) wrote:

>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

  • 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: Newbie help
    ... think I can probably get what I need using SQL Server (the ... > To efficiently store and retrieve data for your needs, ... You only store changed values (as ...
    (microsoft.public.sqlserver.programming)
  • Re: Login failed for user NT AUTHORITYNETWORK SERVICE.
    ... If so you should either create an account for the web app on the sql server and use that account to connect or if you must use windows auth to connect to the sql server then you need to enable impersonation in iis and your web app so that it accesses the db with the credentials of the user that's using the web app through IE. ...
    (microsoft.public.sqlserver.security)
  • Re: meta data & full text search
    ... There are more issues (transaction control, change control, audit of ... storing the files in a SQL Server table's column defined with an IMAGE ... if you store the files ... consistency of the database, indices, backup, restore, etc. ...
    (microsoft.public.sqlserver.fulltext)
  • RE: how to encrypt database password in web.config file
    ... If you want this to work with SQL Server, you must use windows authentication to connect to your SQL Server, but your connection string shows that you are using SQL authentication. ... > However I don't like to store my password in plain text. ...
    (microsoft.public.dotnet.framework.aspnet)