Tuesday, September 6, 2011

Step by Step Guide How to Install Dynamics AX 2012 SSRS and Analysis Extensions

This is the 3rd part in the series - Step by Step Installation of Dynamics AX 2012 Components:

Part 1 - Basic Dynamics AX 2012 Installation http://daxdilip.blogspot.com/2011/08/step-by-step-guide-how-to-install.html

Part 2 - Dynamics AX 2012 Enterprise Portal Installation http://daxdilip.blogspot.com/2011/08/how-to-install-dynamics-ax2012.html


INSTALL REPORTING EXTENSIONS
Run Pre-Requisite Validation

Go to the Link below and Download Cumulative Update 3 for SQL Server 2008 R2
http://support.microsoft.com/?kbid=2261464










Troubleshooting Tip (SSRS Errors)



Error during Install of AX 2012 SSRS Extensions

Microsoft.ReportingServices.WmiProvider.WMIProviderException: The profile for the user is a temporary profile. (Exception from HRESULT: 0x80090024)   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ThrowOnError(ManagementBaseObject mo)
   at Microsoft.ReportingServices.WmiProvider.RSWmiAdmin.ReencryptSecureInformation()
   at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.ReencryptSecureInformation()

An error occurred during setup of Reporting Services extensions.

Reason: Unable to restore the SQL Server Reporting Services encryption key. The operation failed with error code 2148073508


Solution


a. Restart the box

b. In SQL Server 2008, SSRS Reporting Configuration Manager, Under Encryption Keys, Restore the key

c. Generate Backup encryption key for the service account

d. Check you are able to browse Report Server and Report Manager URL

e. Now, Install SSRS Extensions again, it should work



Deploy Reports (Powershell)



Wait for a few mins to populate the variable, it will return back to the PS Prompt
TIP - You can also output to a file by appending out-file as shown


803 SSRS reports out of the box
Publishing reports
Note – takes around 45 mins to deploy (with some warnings which can be ignored I guess)

INSTALL/CONFIGURE ANALYSIS SERVICES
  1. Install SQL Server Analysis
  2. Restart Server










8 comments:

  1. We are unable to install AX 2012 Reports service extension components due to below error and unable to troubleshoot.
    Error Description:
    An error occurred during setup of Reporting Services extensions.
    Reason: A call to the Microsoft Dynamics AX SRSFrameworkService service failed. The target principal name is incorrect.

    ReplyDelete
  2. HI,

    Could you please help me out, Installing AX2012, when i run pre-requsits i've got list of the errors and i couldn't able to configure MDM.

    Please help me out on this.

    Regards

    ReplyDelete
  3. Re the Principal name error, I think you may need to give the server/instance name where SSRS is installed.

    Arif, If you can provide the error descriptions, I can give it a shot.

    Good luck.

    ReplyDelete
  4. SSRS has installed success fully , but while deploying reports am getting following error


    Publish-AXReport : The directory is not empty.
    At C:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities\AxDeployReport
    s.ps1:54 char:20
    + Publish-AXReport <<<< -Id $ConfigId -ReportName "*" -RestartRepo
    rtServer
    + CategoryInfo : OpenError: (Microsoft.Dynam...shReportCommand:Pu
    blishReportCommand) [Publish-AXReport], IOException
    + FullyQualifiedErrorId : The directory is not empty.
    ,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

    **********************
    Windows PowerShell Transcript End

    Even am not getting Dynamics option for creating SSRS report using visual studio 2010.


    Can you please help me.

    ReplyDelete
  5. SSRS has installed success fully , but while deploying reports am getting following error


    Publish-AXReport : The directory is not empty.
    At C:\Program Files\Microsoft Dynamics AX\60\ManagementUtilities\AxDeployReport
    s.ps1:54 char:20
    + Publish-AXReport <<<< -Id $ConfigId -ReportName "*" -RestartRepo
    rtServer
    + CategoryInfo : OpenError: (Microsoft.Dynam...shReportCommand:Pu
    blishReportCommand) [Publish-AXReport], IOException
    + FullyQualifiedErrorId : The directory is not empty.
    ,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand

    **********************
    Windows PowerShell Transcript End

    Even am not getting Dynamics option for creating SSRS report using visual studio 2010.


    Can you please help me.

    ReplyDelete
  6. Dear Friend,

    If you would like to go there upper position related your field then you have to learn New technolgy Microsoft Dynamic ERP (accounting software) GP and AX Finacial & Logistics Module,hopefully onward you will get chance bright position with multinational firm.


    we provide the complete Training Material and self study at Home.


    1.Microsoft Dynamics GP and AX Offline Training Material and E-Learning mterial

    2. MicrosoftDynamics GP and AX Installation Media Disks

    3. Microsoft Dynamics GP and AX VPC Images

    We can ship you the Training Material,

    If there any question just let me back know.





    Regards
    salmankk200@gmail.com

    ReplyDelete
  7. I am installing AX 2012 R2 on Windows Server 2012 and SQL Server 2012. The AOS is installed on one machine. SQL Server is on a second machine. I have installed SSRS on a third machine. I am trying to install the reporting Service extensions but keep getting a reoccurring problem.

    === Setting up Reporting Services extensions ===
    Verifying the credentials for the Microsoft Dynamics AX .NET Business Connector proxy.
    Back up the SQL Server Reporting Services encryption key.
    The reporting server is not set up correctly, and cannot be configured by Setup. For information about setting up a reporting server, see SQL Server Books Online.
    An error occurred during setup of Reporting Services extensions.
    Reason: Unable to back up the SQL Server Reporting Services encryption key. The operation failed with error code 2147945104.
    System.InvalidOperationException: Unable to back up the SQL Server Reporting Services encryption key. The operation failed with error code 2147945104.

    I have followed your suggestions above, deleting and restoring and creating new encryption keys and rebooting the system but all to no avail. Any suggestions?

    ReplyDelete
  8. I think it's good to state where the original encription key is saved, that you need to restore as suggested by Dilip. You can find the name and location in the logfile, just before the error part.

    ReplyDelete