0

A SQL Server 2012 agent job was failing with:

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {...} and APPID {...} to the user MYDOMAIN\me SID (...) from address LocalHost (Using LRPC). This security permission can be modified using the Component Services administrative tool.

But when I looked in Component Services -> Computer -> My Computer -> DCOM Config -> (APPID above), I found that the local Administrators group already had "Local Activation" permission. I confirmed that my domain user account was a member of local group Administrators.

Nevertheless, to run the job, I had to manually add myself and give myself "Local Activation" authorization. Why is this?

0

i've had this issue before!

Here is how I fixed it

So the issue was due to the fact that the NT Service\SQL Server Distributed Replay Client user did not have local activation permissions in the Component Services dialog. The original error message clearly stated that I needed to give local activation permissions to the SQL Server Distributed Replay Client, but it seems that I gave permissions to SQL Server Distributed Replay CONTROLLER instead.

see Component Services Error Log - SQL Server Distributed Replay Client for my original post. Not totally sure if this question is a duplicate or not.

SQL Server Distributed Replay Controller in DCOM

  • Thanks for the answer. I don't think this is the same thing. The error message was about me (user MYDOMAIN\me), not a service account. Adding myself to the ACL fixed the problem, but I'm trying to understand why that was needed in addition to the Administrators group. – jordanpg Apr 3 '14 at 12:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.