I’ve got an issue with an agent trying to access a database on another server. Here’s the scenario.
ServerA and ServerB are clusters.
ApplicationA is a db on both servers and it contains an agent which tries to read docs in a separate database on ServerA.
The agent is set to run as web user and contains functionality which may fall under ‘restricted’ code.
When the agent is executed from ServerA it works fine. When executed from ServerB it does not work. It fails on db.Open().
I checked db ACL and the user has manager access. I checked server access and user has access. The agent does run, which means that it’s not access to run agents on the server.
If I put the user in the LocalDomainAdmins group it works fine. What am I missing?
Any ideas please?
Thanks
Ed