1
Vote

MDW Data Collector SSIS pkg Failure

description

I need some seriously fast assistance with the SQL Server Central Management System. I am a senior engineer, but this is my first run with the MDW. My customer has both SQL v2012 and v2005. I need to support both for an unknown period of time. So - I built the MDW on the v2012 instance using all defaults with the 'Configure Management Data Warehouse'. I have two types of collections -
  1. The normal system collectors (disk usage, query stats, server activity), which sit on my v2012 instances, and target the local engines for the data, and connect to the MDW remotely, to process the data.
  2. The custom data collectors -- they sit on the MDW and target a couple v2005 instances remotely, via linked server. (In place, as of yet untested.)
Right now I am having a problem with the normal system collector, Server Activity. It is defined exactly as it is in the system, no modifications, except that I renamed the associated Agent job. I was first failing to connect to the MDW box via authentication failure. I resolveded this by creating a credential and an agent proxy, and enabling the Agent jobs to run under the proxy. Now I am failing with the error below.

dcexec is fairly new to me. as are executing SSIS pkgs from within msdb, rather than the file system. Given the above error, is anyone able to provide some direction?

Job 'Server_Activity_Upload' : Step 1, 'Collection_Set_33_Upload_Purge_Logs' : Began Executing 2014-04-09 13:39:36

SSIS error. Component name: PerfCountersUpload, Code: -1073663999, Subcomponent: (null), Description: Failed to create mutex "MSSQL11.MSSQLSERVER-{79765A0B-ADB7-4A49-8923-E95451DAD149}-46-PerfCountersLock" with error 0x80070005.

SSIS error. Component name: TaskForCollectionItem_46, Code: -1073602332, Subcomponent: (null), Description: Error 0x80070005 while preparing to load the package. Access is denied.

SSIS error. Component name: TSQLQuery_PDC01WVDB01_MSSQL11_MSSQLSERVER_{79765A0B-ADB7-4A49-8923-E95451DAD149}_45_Upload, Code: -1073663999, Subcomponent: (null), Description: Failed to create mutex "MSSQL11.MSSQLSERVER-{79765A0B-ADB7-4A49-8923-E95451DAD149}-45-TSQLCollectorLock" with error 0x80070005.

SSIS error. Component name: EPT - Run Generated Package, Code: -1073602332, Subcomponent: (null), Description: Error 0x80070005 while preparing to load the package. Access is denied.

The master package exited with error, previous error messages should explain the cause.
Job 'Server_Activity_Upload' : Step 3, 'Send Notification - Failure' : Began Executing 2014-04-09 13:39:39

comments