asp.net connection to sql server?

Hello. Sorry if this is a novice question but can anyone show or point me
to some code in having windows authentication to sql server for an asp.net
application where it's not using just one generic windows account? I need
to assign individual windows logins to our users (basic authentication in
conjunction with https since not everyone is on the same domain). I notice
in pretty much all the examples/samples I see on the net they have the
asp.net apps use 1 generic or surrogate windows connection to sql server
that's on the same domain but how does one configure the asp.net app to
allow individual windows authentication for users to access the asp.net app
from anywhere on the web? The reason I'm asking is because I need to use
SQL Profiler in seeing who did what to the data at what time, etc...

Thanks in advance.

J


.

Relevant Pages

  • ADO.NET 2.0 & MSDE & Win98
    ... Framework 2.0 which must be deployed on Windows 98 platform. ... The MSDE will ... be installed on Win98 as the SQL Server to which the app will connect. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SqlExpress distribution and access rights
    ... Is this app with SQL Server Epxress a server app or a desktop app? ... Since you want useraccess the SQL Server with Windows integrated security, and you, of course, do not know what user account the user is using when developing the app. ... you can also incorporate the Windows local user group setup into your installation package. ...
    (microsoft.public.sqlserver.msde)
  • Re: Windows security
    ... sp_change_users_password only works with SQL Server ... Authentication, not Windows Authentication. ... > Windows NT environment but still have entries in the Microsoft SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Bizzare SQL Network Error
    ... The bizzare thing is that, the same connection string, the same code to ... In a windows APP it works fine, in a Web APP I get ... >>I am trying to connect to a default instance of SQL Server 2000 Enterprise ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Why do I have to enable File and Printer sharing to connect through the XP firewall?
    ... connecting using a Windows account or using a SQL Server account? ... For Windows authentication, SQL Server need to enumerate the SIDs for the account you pass with Windows. ...
    (microsoft.public.sqlserver.clients)