|
it
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Call exe / permission issueI have an exe (VB) that basically performs updating and table inserts.
Currently, a user would simply double click the exe to execute. Now I want to call this from ASP. When I do so, my log file (which is created w/in the exe) says that 'Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.' Now my db connection string in the exe is set to use Integrated Security. Within IIS, I'm using anonymous access with 'WebUser' as my username. I granted this user full control under security for the exe. Again, if I simply double click the exe and run it, all is well. But calling it from the asp page gives me the login failed response. "Eric" <E***@discussions.microsoft.com> wrote in message Full control of what? You need to grant 'WebUser' the appropriate access innews:6A888870-E398-4BD3-BAF1-218631B7ED74@microsoft.com... > I have an exe (VB) that basically performs updating and table inserts. > Currently, a user would simply double click the exe to execute. > > Now I want to call this from ASP. When I do so, my log file (which is > created w/in the exe) says that 'Login failed for user '(null)'. Reason: Not > associated with a trusted SQL Server connection.' > > Now my db connection string in the exe is set to use Integrated Security. > Within IIS, I'm using anonymous access with 'WebUser' as my username. I > granted this user full control SQL Server to SPs and/or other objects that the Exe may modify. Also it would be better if you moved all this to a DLL and create a EXE to call the DLL. Then simply use the DLL from ASP rather than launching another process to do the work. Show quoteHide quote >under security for the exe. Again, if I > simply double click the exe and run it, all is well. But calling it from the > asp page gives me the login failed response.
Other interesting topics
random record with SELECT TOP does NOT work
FORM and javascript.location how to choose a random record from a database Server.Transfer and Load Balanced Environments Need a good Book How do I do this with ADO and an Access DB in ASP 3.0? Session Variables Question Connecting to a msaccess project database adp How to Detect the trusted site and add it via scripting? File Listing |
|||||||||||||||||||||||