[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-dev
Subject:    Re: Problems with DBD::ODBC and Authentication
From:       David Edwards <edwardsd () deev ! com>
Date:       1998-11-28 22:53:27
[Download RAW message or body]

    *** From dbi-users -- To unsubscribe, see the end of this message. ***

Hello Daniel,

I've been lurking around for 9 months or so :-)

Finally think I can actually help somebody.

Go to the Microsoft site and search their knowledge base on IIS and 
authentication.  You will find an article explaining that if you use NT 
authentication for IIS then you can't use a trusted connected from IIS to 
SQL Server6.5.  You have to use a different authentication method to 
connect to SQL server.  You may wish to also consider using an alernate 
form of authentication on IIS - depending on your application this may or 
may not be an option for you.

I know we had this problem at work.   Search the Microsoft Knowledge 
Base.  I may have explained it a bit wrong but your problem is 
essentially what I am trying to describe for you.

Cheers

/david/

On Fri, 27 Nov 1998, Daniel Cane wrote:

>     *** From dbi-users -- To unsubscribe, see the end of this message. ***
> 
> Hey all -- happy holidays!
> I'm having a small problem-- here's the scoop:
> 
> Running NT4/SP4 w/IIS4 connecting through DBD::ODBC to MSSQL65. Normally
> things are peachy, except if we attempt to use *any* sort of
> authentication that uses an ODBC datasource. We tried different DSN's
> and still no luck. We were originally using MS's IIS-Authenticaiton SDK,
> and thought that maybe that was the problem, but then we wrote our own
> custom DLL to handle authentication with the same results. Both of them
> cause IIS to hang. Removing the authentication removes the problem!?!
> Has anyone had any degree of success authenticating to an through ODBC
> to a user/passwd table while still using ODBC to connect to the
> database? The -goal- of all this is to make something similar to AuthDBI
> (Apache) but for IIS (and yes, IIS is required for this project :) ) 
> 
> Thanks all, and hope you have a stuffed belly from the holiday. 
> 
> Dan
> 
> ===============================================================
> Daniel Cane
> Sr. V.P. for Professional Services
> Blackboard, Inc.
> 1111 19TH St., Suite #608
> Washington, DC 
> dcane@blackboard.net         Voice: (202) 463-4860 x.204
> http://www.blackboard.net      Fax: (202) 463-4865
> ================================================================ 
> 
> 
> ------------------------------------------------------------------------------
> To unsubscribe from this list, please visit http://www.fugue.com/dbi
> If you are without web access, or if you are having trouble with the web page,
> please send mail to dbi-request@fugue.com.   Please try to use the web
> page first - it will take a long time for your request to be processed by hand.
> ------------------------------------------------------------------------------
> 


------------------------------------------------------------------------------
To unsubscribe from this list, please visit http://www.fugue.com/dbi
If you are without web access, or if you are having trouble with the web page,
please send mail to dbi-request@fugue.com.   Please try to use the web
page first - it will take a long time for your request to be processed by hand.
------------------------------------------------------------------------------

[prev in list] [next in list] [prev in thread] [next in thread]