General information
Category:
Internet applications
>>I have an .asp page that called a VFP DLL. The DLL lookups some data in SQL Server and returns an XML to the .asp page.
>>
>>Works great, but I cannot seem to get it set so that the dll can be called with no user logged in (no desktop). Probably a simple user rights I am missing. Suggestions?
>
>Not sure why you are getting a permissions error - you shouldn't have a problem if you're not accessing local disk data directly. How is the SQL Connection set up? If you are using Windows security on the connection (rather than a SQL Server account) then that may be the problem as by default IIS configures a Application Pool identity that is generated and is unlikely to have rights to access your SQL Server (or any disk based resources).
>
>You can set the Application Pool identity on the Application Pool in the IIS Manager. I suggest either setting up a custom account or if you use something generic use Network Service and then adjust your permissions to the DB to allow for that account to connect to SQL Server if you're using Windows auth.
>
>The easier solution may just be though to use SQL Server auth with user name and password which **should** bypass the whole Identity issue.
>
>+++ Rick ---
I was not clear enough; the problem is loading the vfp dll, not the SQL connection.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only