Monday, January 12, 2015

SQL Agent DCOM error Event ID 10016

I got this error in my event log ID 10016 of my database server installed with Windows Server 2012, in which i have only installed SQL server 2012 database. It was running fine since last 15 days but since yesterday I have got a new problem in it is that i am unable to shut down this very server although i am doing the same with administrator account. It is in domain and none of the policies are implemented in it. I searched a lot on all blogs and even tried some nut none worked. The error is mentioned herein under.
The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID 
 and APPID 
 to the user NT SERVICE\SQL Server Distributed Replay Client SID (S-1-5-80-3249811479-2167633679-2115734285-1138413726-166979568) from address LocalHost (Using LRPC) running in the application container Unavailable SID (Unavailable). This security permission can be modified using the Component Services administrative tool.

After googling i found the below  solutions and that worked for me.

Component services –> computers –> my computer –>DCOM config->MSDTSServer100 
    Right click and select Properties 
    Launch and Activate permissions – edit 
Add the local SQL AgentUser and enable local launch and Local activation.

No comments:

Post a Comment