SQLServer login with Trusted Connection thru ASP

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Jim Corey (jcorey_at_nospamcharter.net)
Date: 12/28/04 

Date: Tue, 28 Dec 2004 10:50:19 -0800

We're looking at logging on to SQLServer using Windows Authentication
from an ASP app, and trying to figure out what will work.

The following connection string works with Basic Authentication:
  driver={SQL
Server};SERVER=MyServer;Database=MyDB;Trusted_Connection=yes;

Is there a way to do this with IIS security set to Integrated Windows
Authentication?

More: This is an existing app where currently each user has a database
login. We want to get away from that. Another option would be to
create a database user for the app, so we may do that. Any opinions
welcome.

TIA,
Jim

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • how can I tell if impersonation is working in ASP.Net web app?
    ... privileged account, I was told to set up an app using Integrated ... Windows authentication and to use impersonation. ... is running under the "ASPNET" username, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: VPN & Windows authentication
    ... and my web apps can continue to use Windows authentication ... the login box (dunno what you call that box...NTML? ... my app knows who they are and can read their AD groups. ... regular users it cannot authenticate their credentials. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: data access strategy
    ... there is a domain which is why my app was originally setup to use windows authentication. ... So temporary way is to use the VPN but I'd like to build a module of my app to run on a windows mobile device so I'll keep trying to get remote DB access working......unless this is a really bad idea. ...
    (microsoft.public.sqlserver.connect)
  • Re: can winforms SET a cookie? will this work?
    ... Enable the windows authentication for your web application, ... enable/disable users/groups from the web.config file. ... > (i can get those from the batch job and pass them to the winform app?). ... > cookie and determine if the person using this app has rights to the ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Safest way to pass data between web apps?
    ... I have an asp.net application that uses windows authentication. ... Both systems use the same user information so once ... the other app to avoid making users log in two times. ...
    (microsoft.public.dotnet.framework.aspnet.security)