in reply to Spawning processes from Microsoft IIS?

If it runs fine on the command line but does not run through a web page, the first thing that comes to mind are permissions issues.
  • Comment on Re: Spawning processes from Microsoft IIS?

Replies are listed 'Best First'.
Re^2: Spawning processes from Microsoft IIS?
by gfunk (Initiate) on Jul 02, 2008 at 18:01 UTC
    I think you're right. After some more tracing, it seems my server process actually launches but the first thing it does is make an dbi::ODBC database connection attempt, which fails. So, arg I'm dumb.

    FWIW, the IIS worker processes seem to run under the user "NETWORK SERVICE". I wonder if I just need to get my SQL Server to allow that user to connect/login.

    Can't connect to dbi:ODBC:Profiler: MicrosoftODBC SQL Server DriverShared MemorySSL Security error (SQL-08001) state was 08001 now 01000 MicrosoftODBC SQL Server DriverShared MemoryConnectionOpen (SECDoClientHandshake()). (SQL-01000)

      I am running into this same exact problem but were having issues attempting to set up the connection including NETWORK SERVICES as a user in ODBC Data Sources.