Page 1 of 1

Connecting to a database from an ISAPI

Posted: Sun 27 Feb 2005 14:33
by ISAPIs
Hi,

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

Thanks
Dan

Posted: Wed 02 Mar 2005 07:23
by Ikar
What authentication way (MSConnection.Authentication) do you use? If auWindows you have to change MS SQL Server settings.

yepp - your spot on

Posted: Thu 31 Mar 2005 17:46
by ISAPI
swapped to Server authentication (had to re-install test server to mixed mode) hung it all together and worked first time.

You rock Ikar

Cheers