Help! Problem when running CF under a non-default service account

[jhendr15]

I am running ColdFusion 9 with IIS 7 on Windows Server 2008.

The CF application service is running under a domain application account rather than the default local.

The problem is when doing so failed templates keep an active request open indefinately.

Is there a permission setting I might be missing to resolve this issue?

Thanks for any help any one can provide.

[jhendr15]

The only documentation related to setting up CF under a different account is about 6 years old for older OS / IIS / CF.

http://helpx.adobe.com/coldfusion/kb/running-coldfusion-specific-user.html

What might be different in current versions?

[Charlie Arehart]

What do you mean by “failed templates keep an active request open indefinitely”? What means are you using to confirm that a “request is open indefinitely”? That’s a sincere question. I’d focus on that before digging into permissions, etc.

/charlie

[jhendr15]

Only when running CF under a domain account does the following occur:

If we have a cfm page that connects to a DB via a query tag and for some reason the query has an error,

Then it can be observed that the request to that page remains active as seen in the server monitor under statisitcs / Active Requests, it stays active and never closes although it should close.  Over time such open threads add up until the Maximum number of simultaneous template requests limit is reached.

For some reason the request does not close as it should, but if we run the CF under the default system account this does not occur.  I can only assume then the domain account has a permission issue.  It currently does not have Full Control on the ColdFusion9 directory so I will try that next.

[jhendr15 · Accepted solution]

Charlie, thank you for your response.

We had only read/write permissions for the account on coldfusion9 directory; after changing to Full Control the problem was resolved.  Charlie, thank you for your response.

[Charlie Arehart]

Thanks for the update. I notice you marked the thread answered, but you marked your reply to me as the answer. I don’t pay too much attention to such things, usually, but it caught my eye and I just wanted to point it out, if it wasn’t intentional.

/charlie