Sample Header Ad - 728x90

Error When Trying to Run MDW Data Collector

2 votes
1 answer
325 views
I have SQL Server Management Data Warehouse (MDW) set up across multiple instances, all in the same way with the same accounts and permissions. On one server I get an error when trying to run the data collectors. The error states that SSIS packages for the data collectors are missing. True enough, when I check SELECT * FROM msdb.dbo.sysssispackages, 8 packages relating to collecting and uploading are missing. In addition, system logs showed the following error: > 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} Does anyone know a fix for this? It is really odd, since all my other instances are running the data collectors without issues. I am running SQL Server 2012 and my host MDW database is on a remote server. But again, all other MDW instances collect and upload without error. I saw SQL Server 2012 Integration Services and DCOM Permissions by John Veazey, which has a common fix for people but it didn't work for me. The sys log error went away, but the error when running data collection persists.
Asked by choloboy (83 rep)
May 12, 2016, 07:11 PM
Last activity: May 13, 2016, 12:32 PM