Friday, August 14, 2015

The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {FDC3723D-1588-4BA3-92D4-42C430735D7D} and APPID {83B33982-693D-4824-B42E-7196AE61BB05}

To fix the error from Event Viewer, I refered to MS website

https://connect.microsoft.com/SQLServer/feedback/details/780569/mdw-job-on-mdw-server-generates-event-10016-distributedcom-error-in-system-log


The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID 
{FDC3723D-1588-4BA3-92D4-42C430735D7D}
 and APPID 
{83B33982-693D-4824-B42E-7196AE61BB05}

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.


No comments:

Post a Comment

How to add a Database to AlwaysOn Availability Group with four different options

To add a database to an existing AlwaysOn availability group, MS has given us four options to choose from Automatic seeding Full database an...