Re: SQLServer login with Trusted Connection thru ASP
From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 12/28/04
- Next message: Roland Hall: "Re: single line XML file"
- Previous message: Ray Costanzo [MVP]: "Re: SQLServer login with Trusted Connection thru ASP"
- In reply to: Jim Corey: "SQLServer login with Trusted Connection thru ASP"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 28 Dec 2004 14:01:14 -0500
Jim Corey wrote:
> 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
>
This article should contain all you need to know to do this. Pay attention
and follow the links in the article where relevant:
http://www.aspfaq.com/show.asp?id=2126
Bob Barrows
-- Microsoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup.
- Next message: Roland Hall: "Re: single line XML file"
- Previous message: Ray Costanzo [MVP]: "Re: SQLServer login with Trusted Connection thru ASP"
- In reply to: Jim Corey: "SQLServer login with Trusted Connection thru ASP"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
