Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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

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

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

↑ Back to the top

Resolution

To resolve this issue, follow these steps:
  1. Open SQL Server Business Intelligence Development Studio.
  2. On the File menu, click 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, click Save <PackageName> As on the SQL Server Business Intelligence Development Studio toolbar, and then save the package to your desktop.
  8. Log on 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 are prompted, overwrite the existing package.

↑ Back to the top

Keywords: kbmbsmigrate, kbmbspartner, kbsurveynew, kbsolomon, kb

↑ Back to the top

Article Info
Article ID : 2567458
Revision : 2
Created on : 2/3/2017
Published on : 2/3/2017
Exists online : False
Views : 74