MDW - job on MDW server generates Event 10016 (DistributedCOM-Error) in system log - by Kunk

Status : 


Sign in
to vote
ID 780569 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 3/4/2013 5:20:23 AM
Access Restriction Public


I installed MDW (Mangement Data Warehouse) on a SQL Server 2012. I activate the system data collection on that system too. Since that I found several DistributedCOM-Errors in the system event log ( event ID 10016) every time one of the data collection jobs  is running.
Her is the complete error message :

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID 
 and APPID 
 to the user NETRTLSRV\SvcSQLServerAgent SID (S-1-5-21-2585614801-172033302-3695164279-1158) from address LocalHost (Using LRPC). This security permission can be modified using the Component S
ervices administrative tool.

I searched the registry for CLSID {FDC3723D-1588-4BA3-92D4-42C430735D7D} an found that it is the service MsDtsServer110 (Microsoft.SqlServer.Dts.Server.DtsServer) and has something to with integrated services.
Furthermore I found some older entries in the internet talking about DCOM-Config in Component Services for MSDTServer100. On other servers running MS SQL Server 2008 R2 I can find a MsDtsServer100 entry in DCOM-Config. 
But for SQL Server 2012 there isn't a MsDtsServer110 entry in DCOM-Config.

1. Where is that entry ?
2. What can I do to add the entry ?
3. How can I config DCOM security so that local data collection jobs didn't generate event 10016 entries in the system error log ?

By the way, data collection on other server remotely connecting the  MDW-server didn't generate any 10016 event!

Wolfgang Kunk
Sign in to post a comment.
Posted by Kunk on 4/17/2013 at 12:47 AM
1. In the meantime I opened a regular Case. Mr. Cezar Ionescu [] handles this case.

2. The workaround you offered seems to solve the problem. I will inform MS Support regarding this workarounf
Posted by Microsoft on 4/16/2013 at 2:59 PM
Please let us know if the posted workaroudn solves your problem

Posted by Sethu Srinivasan on 4/16/2013 at 2:58 PM
Let us know if this workaround solves your issue
1)    Run Dcomcnfg.exe
2)    Expand Component Service -> My Computer ->DCOM Config
3)    Locate “Microsoft SQL Server Integration Services 11.0”
4)    Right click and select “Properties”
5)    Select “Security” tab
6)    In Launch and Activate Permissions, click on “Edit”
7)    Grant “Local Launch”, “Local Activation” permissions for SQL Agent Service account
8)    Restart all Data collectors, Check Windows System Event log for any DCOM errors that you were seeing before.

Sethu Srinivasan [MSFT]
Posted by Microsoft on 3/4/2013 at 2:31 PM
Hello Kunk. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (