Connecting to a database from an ISAPI

[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

[Ikar]

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

[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