I keep getting this message when trying to run a WebQuerySave Agent.
I’ve looked through the forum and found a few bits and pieces including, make sure that you are listed in the server document May run Restricted Agents, which I am and sign the agent with the Server ID, which works. The only problem with signing the agent with the server id is that it means signing the database after each little change and as it signs it in the background it can take a minute to reflect.
I’ve tried to get the agent to run on behalf of the server, but it says that I don’t have the right to do that, which makes sence if I don’t have the right to run agents anyway.
If anyone has any ideas, they would be gratefully appreciated. It’s going to be something really silly, I’m sure.
Thanks
Ross