"Failed to decrypt protected XML node" error in SQL Server Agent Job History event log when you use Microsoft BIO with Microsoft Dynamics SL

  • Article

This article provides a solution to an error that occurs in the SQL Server Agent's job history event log when schedule a Microsoft SQL job to process the BIO cubes.

Applies to:   Microsoft Dynamics SL
Original KB number:   2567458

Symptoms

When you schedule a Microsoft SQL job to process the BIO cubes, you receive the following error message in the SQL Server Agent's job history event log:

Description: Failed to decrypt protected XML node

Resolution

To resolve this issue, follow these steps:

  1. Open SQL Server Business Intelligence Development Studio.
  2. On the File menu, select New Project, and then select Integration Services Project.
  3. Right-click SSIS Packages, and then select Add Existing Package.
  4. Select the Cube processing package to add in the SSIS Package window.
  5. In the upper-right corner of Visual Studio, double-click the package in Solution Explorer.
  6. Edit the BIO_SQL connection in the Connection Manager window and select the Windows Authentication option.
  7. On the File menu, select Save <PackageName> As on the SQL Server Business Intelligence Development Studio toolbar, and then save the package to your desktop.
  8. Sign in to Microsoft SQL Server Management Studio, and then right-click the MSDB folder under the SSIS instance.
  9. Select Import Package, and then select the package that you saved to your desktop.
  10. When you're prompted, overwrite the existing package.