This video explains how to deploy and configure a Dynamics Ax 2012 SSRS Server deployment. The SQL SSRS service is the foundation for native Ax reports. There are several "gotchas". The configuration is very meticulous. This covers how to install the SQL SSRS Instance, configure the SSRS instance, installation of required
Ax components, Ax custom report server extensions, Ax SSRS application configuration for multi-instance SSRS deployment, report deployment and validation. You want to grab a cup of coffee for this one.
DK SSRS Reference Documentation
Detailed documentation can be found below:
How to Deploy / Configure Dynamics Ax 2012 SSRS
Step-by-Step
- Part 1: Ax SSRS Architecture Overview
- Part 2: Installing SQL SSRS Instance
- Part 3: Ax Component Requirements
- Part 4: SQL SSRS Configuration
- Part 5: Ax Configuration Overview
- Part 6: Ax Report Server Extensions
- Part 7: Updating Report Server Instance Bin Folder
- Part 8: Ax SSRS Application Configuration
- Part 9: Ax Report Deployment
- Part 10: Testing / Validation
Part 1: Ax SSRS Architecture Overview
[Training Video]
- Overview of Dynamics Ax SSRS Architecture
- Multi-Instance SSRS
Part 2: Installing SQL SSRS Instance
[Training Video]
[FreshDesk KB Article]
- Source Files
- Installation Requirements
- Service Accounts
- Component Configuration
- Report Server Database Deployment
Part 3: Ax Component Requirements
[Training Video]
[FreshDesk KB Article]
- Ax Report Service Installation
- Prerequisites
Part 4: SQL SSRS Configuration
[Training Video]
[FreshDesk KB Article]
- Service Accounts
- Website Configuration
- SQL Proxy Account
- Connecting SSRS to database
Part 5: Ax Configuration Overview
[Training Video]
Part 6: Ax Report Server Extensions
[Training Video]
[FreshDesk KB Article]
- Ax Management Shell
- Command Parameters
Part 7: Updating Report Server Instance Bin Folder
[Training Video]
[FreshDesk KB Article]
- Client .axc config file
- Bin folder location
Part 8: Ax SSRS Application Configuration
[Training Video]
[FreshDesk KB Article]
- Application Configuration
- Naming Conventions / Standards
- SSRS Server Registration
- Creating Ax SSRS Folder
- Configure Report Server URL's
- Connecting to AOS Instance
Part 9: Ax Report Deployment
[Training Video]
[FreshDesk KB Article]
- Ax PowerShell
- Command Line Parameters
Part 10: Testing / Validation
[Training Video]
[FreshDesk KB Article]
- Test Scenario