Home Forums Reporting Services Reporting Services Design Question: What is the best practice for reporting on data that spans instances? RE: Design Question: What is the best practice for reporting on data that spans instances?

  • Jack Corbett (2/26/2014)


    You should search for Rodney Landrum DBA Repository as that might be the kind of template you'd want to follow.

    Jack,

    Since you are familiar with Rodney's DBA Repositiory, have you ever seen the following error:

    TITLE: Package Validation Error

    ------------------------------

    Package Validation Error

    ------------------------------

    ADDITIONAL INFORMATION:

    Error at Backup History [OLE DB Source [46]]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MultiServer" failed with error code 0xC0014041. There may be error messages posted before this with more information on why the AcquireConnection method call failed.

    Error at Backup History [SSIS.Pipeline]: OLE DB Source failed validation and returned error code 0xC020801C.

    Error at Backup History [SSIS.Pipeline]: One or more component failed validation.

    Error at Backup History: There were errors during task validation.

    Error at Populate_DBA_REP: The connection manager "MultiServer" will not acquire a connection because the connection manager OfflineMode property is TRUE. When the OfflineMode is TRUE, connections cannot be acquired.

    (Microsoft.DataTransformationServices.VsIntegration)

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    I am getting it in the Multiserver object of the Populate_DBA_REP.dtsx package.

    I have googled to no avail. I don't see anywhere to change "the connection manager OfflineMode property." OfflineMode is set to False, and looks grayed out.

    Any ideas?

    J