epPlanningService8 Service Account

[Matt toth]

All,

I have items queued that will not run and found that the service account needs to be a local admin.  I tried this, but now I think it needs to be a user that has sql server rights.

Version 7.3 had com objects that used this account to connect to sql server, but 8.4 does not appear to use com objects.  Maybe the logic is the same.

Is there anything else that I am missing to get the Reconcile from Queued to Running?

Thank you,

Matt

[ericlfg]

Hi Matt,

This particular behavior is common and there's a few things I would confirm before making changes to the services.

1. Ensure that the application is added to a job server or cluster.  Also confirm that the "planning store resource" is added to a job server or cluster.
2. Try disabling the job processing at the cluster level and then re-enable it.
3. If neither of the two items above didn't resolve it, you could try rebuilding the cluster by deleting the job servers and deleting the cluster and rebuilding it again.  You would then have to re-add all the application and publish container objects back to either the cluster level or specific job server levels.

Cheers

[ovo]

.... and

4. Check and update your scheduler credentials to make sure they are valid.

The login you use for the account only needs to be a SQL Server account if you are using trusted connections.  Otherwise all database logins should you the account you specified when you created your datastores, apps, etc.

[Matt toth]

Ovo,

Thank you - deleting and recreating the job servers worked the best.  I have sucessfully GTP'd.

Matt