I have agent with option run behalf of. In that field(run behalf of ) is person with "run unrestricted operation " in server configuration.Inside agent i want to open database where i dont have access but the person in “behalf of fileld” have it. When i run agent i have massage: User X don’t have access to database. I dont why agent don’t do open operation as another person(person in run behalf of filed) Thanks in advance.
Subject: Problem with agent to run behalf of
Do you have the right to create agents that run on behalf of another user?
Did you provide the full cannonical name of that other user?
Subject: RE: Problem with agent to run behalf of
Yes i have it.
Subject: RE: Problem with agent to run behalf of
Is the target database on the same server?
Subject: RE: Problem with agent to run behalf of
Yes it is. I think that option run beahalf of works only when agent i scheduled agnet and trrigerd automaticaly. I tried to triger scheduled agent with @command([RunAgent]) from another agent trigerred form menu, and tahe it does’nt work.