[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
Security=SSPI"
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
jaildivuser.
Strange problem is that no where in the asp code is the user id
jaildivuser referenced.
any ideas of how to straighten this out?
thanks
>
>
*
*
*
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