
May 3rd, 2006, 02:39 PM
|
|
Registered User
|
|
Join Date: May 2006
Posts: 1
Time spent in forums: 1 m 2 sec
Reputation Power: 0
|
|
|
Permissions problems with Integrated authentication
Hi, I have an ISAPI DLL web application and am having problems connecting to a SQL Server 2000 database when using IIS Integrated Windows Authentication. The error I get is a 'cannot locate or connect to sql server' message. If I use anonamous access it works fine. I need to use Integrated Authentication as I have an asp page that uses a server variable to get the users logon name.
I have even tried setting the anonamous account in IIS as my domain account which works, then setting IIS to Integrated and loggin in to the machine and connecting via the browser with the same account and this doesn't work. I have security auditing on the machine and it has not returned any access violations.
Any sugestions would be very appreciated.
Paul
|