Groups | Blog | Home
all groups > iis security > october 2003 >

iis security : DSN connection fails when Basic authentication turned on


Drew
10/28/2003 9:43:24 AM
Just rebuilt my Web server and added back all the user
accounts. When I switch on Basic Authentication, the ASP
that pull information from the SQL server fail to make the
DSN connection with the following message:-
"Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC SQL Server Driver]Client unable to
establish connection"

When I turn the basic authentication off and turn on
anonymous it works fine.

Any suggestions?

drew
Tom Kaminski [MVP]
10/28/2003 3:38:53 PM
Start here:
http://www.aspfaq.com/show.asp?id=2009

--
Tom Kaminski IIS MVP
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://mvp.support.microsoft.com/
http://www.microsoft.com/windowsserver2003/community/centers/iis/

[quoted text, click to view]

Paul Lynch
10/28/2003 8:39:14 PM
Drew,

Start here :

http://www.aspfaq.com/show.asp?id=2009

PRB: "Client Unable to Establish Connection" Error Message When
Connecting from ASP to SQL Server
http://support.microsoft.com/?id=253500


Regards,

Paul Lynch
Drew
10/29/2003 11:01:28 AM
Traced the fault down to using named pipes in the DSN
connection. Changed to TCP/IP and now works.

Drew


[quoted text, click to view]
AddThis Social Bookmark Button