Re: asp.net connection to sql server?

http://www.connectionstrings.com/?carrier=sqlserver





"J" <IDontLikeSpam@xxxxxxxxxxx> wrote in message
news:u%23n0hO$OHHA.4372@xxxxxxxxxxxxxxxxxxxxxxx
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

  • Re: connection options to yukon
    ... If you use TLS you can increase the security of your SQL auth ... Windows auth is slower as the domain must ... >> My recommendation would be to use Windows authentication over sql Auth ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Connection Issue : SQL Server 2005 install on XPpro when connecting from a XPpro machine
    ... I think you are trying to mix the use of windows authentication and SQL authentication. ... With Windows authentication you don't specify a username it uses the user you are logged in as. ... For this to work you need to in a domain where the user on your machine is a domain user and then assign that user access on the server. ...
    (microsoft.public.sqlserver.connect)
  • Re: please Help-changed from mixed windows authentication tho windows only locked out
    ... If you are trying to connect using Enterprise Manager, then delete the SQL ... Server registration first, and reregister with Windows authentication. ...
    (microsoft.public.sqlserver.security)
  • Re: SP3a wont install
    ... It's not clear to me whether you are using SQL or Windows Authentication? ... > will not install because it cannot verify user either in ...
    (microsoft.public.sqlserver.setup)
  • Re: Security question
    ... Using Windows authentication, you will be authenticating using the process ... then you can give the ASPNET account rights to your SQL ...
    (microsoft.public.sqlserver.security)