Connecting to a database from an ISAPI

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Connecting to a database from an ISAPI

Post by ISAPIs » Sun 27 Feb 2005 14:33


I've got a database setup in MS SQL and can connect to it from a normal desktop application. But when I port the code to an ISAPI and run it from local host I'm getting permission problems.

I think it's something to do with the security model around the IIS being different to the logged in user

But I'm not really too sure

Has anyone got any clues either on changing the acess settings on the datbase or on changing the permissions on IIS. I do not want the database to be web accessible


Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Post by Ikar » Wed 02 Mar 2005 07:23

What authentication way (MSConnection.Authentication) do you use? If auWindows you have to change MS SQL Server settings.


yepp - your spot on

Post by ISAPI » Thu 31 Mar 2005 17:46

swapped to Server authentication (had to re-install test server to mixed mode) hung it all together and worked first time.

You rock Ikar


Post Reply