[thelist] asp to sql using Integrated Security=SSPI

Brian Delaney brian.delaney at mccmh.net
Wed Jul 28 13:29:12 CDT 2004

issue is as such:  I have a Intranet web app that connects to sql 2000 
via asp.

my ado connection string is as such: adoCon.OPen "Provider=SQLOLEDB; 
Data Source=SQLDEV\SQLDEV; Initial Catalog=JAILRR; Integrated 

The sql database has only one user id(logon) associated with it: 
jaildivuser. It is a  sql account and not a windows domain account.

My objective was that the windows users logged in and using the app 
would be passed to sql using this string.

When the app runs you can see in the sql logs a successfull login for 

Strange problem is that no where in the asp code is the user id 
jaildivuser referenced.

any ideas of how to straighten this out?



This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or priveleged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.

More information about the thelist mailing list