Before you install the Reporting Services extensions

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

Before you install the Microsoft SQL Server Reporting Services extensions, you must complete the following procedures.

Verify that you have the required permissions to install the Reporting Services extensions

To install the Reporting Services extensions, you must have the required permissions. For more information, see Verify that you have the required permissions for installation.

Assign system service accounts to the appropriate Active Directory groups

Identify which accounts are used for the following purposes:

• The account used to run the Microsoft Dynamics AX Application Object Server (AOS)

• The account used as the Business Connector proxy

Assign the accounts listed above to the following Active Directory groups on the domain server:

• Windows Authorization Access group

• Pre-Windows 2000 Compatibility Access group

Install prerequisites

On the computer where Reporting Services is installed, or where you plan to install Reporting Services, run the prerequisite validation utility to verify that system requirements have been met. For information about how to run the prerequisite validation utility, see Check prerequisites.

For more information about the hardware and software requirements for Microsoft Dynamics AX, see the system requirements.

Configure Reporting Services in native mode

If you installed Reporting Services in native mode, you must complete the following procedures to configure the Reporting Services instance.

Configure the Reporting Services instance by using the Reporting Services Configuration Manager tool

Use the following procedure to configure the Reporting Services instance.

Note

If you installed the Reporting Services instance in its default configuration, Reporting Services is already configured for you. However, we recommend that you complete this procedure to verify that the options are configured correctly.

1. Click Start > All Programs > Microsoft SQL Server > Configuration Tools > Reporting Services Configuration Manager to open Reporting Services Configuration Manager.

2. Connect to your Reporting Services instance.

3. Configure the options that are described in the following table. For detailed information about each option, see the SQL Server documentation.

   Click this option…	To do this…
   [ServerName]\[InstanceName]	Verify that the Reporting Services instance is running. If it is not running, click Start.
   Service Account	The action that you should take depends on the configuration mode that you selected when you installed the Reporting Services instance. If you installed the default configuration for native mode, no action is required. The service account is set to the account that you specified when you installed the Reporting Services instance. If you installed but did not configure the report server, select the Network Service built-in account. Note When you install the Reporting Services extensions, the Business Connector proxy account is automatically assigned as the service account for the Reporting Services instance.
   Web Service URL	Create a virtual directory for the Reporting Services web service. By default, the virtual directory is named ReportServer, and the URL is http://[SSRSServerName]:80/ReportServer.
   Database	Create a database for the Reporting Services instance. By default, the database is named ReportServer.
   Report Manager URL	Create a virtual directory for Report Manager. Report Manager is the website that reports are published to. By default, the virtual directory is named Reports, and the URL is http://[SSRSServerName]:80/Reports.
   E-mail Settings	This option is not required. For more information, see the SQL Server documentation.
   Execution Account	Take no action. Note When you install the Reporting Services extensions, the Business Connector proxy account is automatically assigned as the execution account for the Reporting Services instance.
   Encryption Keys	This option is not required. For more information, see the SQL Server documentation.
   Scale-out Deployment	This option is not required. For more information, see the SQL Server documentation.

4. Click Exit to close Reporting Services Configuration Manager.

Configure the Reporting Services instance for local administration

To administer an instance of the report server locally, you must complete additional configuration steps when you deploy Reporting Services on Windows Server 2008. Windows Server 2008 limits the overuse of elevated permissions by removing administrator permissions when you access applications. If you are a member of the local Administrators group, you run most applications as if you are using the Standard User account because the operating system removes permissions.

Although this practice improves the overall security of your system, it prevents you from using the predefined, built-in role assignments that Reporting Services creates for local administrators. However, by completing additional configuration steps, you can manage the report server's content and operations by using standard user permissions. For instructions, see How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 on TechNet.

After you have configured the Reporting Services instance for local administration, verify that you can access the websites that are listed in the following table.

Website	Default URL
Reporting Services web service	http://[SSRSServerName]:80/ReportServer
Report Manager	http://[SSRSServerName]:80/Reports

Configure Reporting Services in SharePoint integrated mode

If you installed Reporting Services in SharePoint integrated mode, use one of the following procedures to configure the Reporting Services instance. The procedure that you should use depends on the version of SQL Server that you are using.

Note

SharePoint integrated mode is supported if you are using Microsoft Dynamics AX 2012 R2 or later.

Configure Reporting Services 2008 in SharePoint integrated mode

If you are using Reporting Services 2008 or Reporting Services 2008 R2, follow these steps to configure Reporting Services in SharePoint integrated mode.

1. Configure Reporting Services by using the following topics in the SQL Server documentation:

   • How to: Install and Configure SharePoint Integration on a Stand-alone Server

   • How to: Install and Configure SharePoint Integration on Multiple Servers

   Note

   When you configure Reporting Services, set the Reporting Services service account and execution account to the Business Connector proxy account.

2. Configure the Reporting Services integration in SharePoint Central Administration. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration in the SQL Server documentation.

3. Verify that you can access the websites that are listed in the following table.

   Website	Default URL
   Reporting Services web service	http://[SSRSServerName]:80/ReportServer
   SharePoint site	The URL of the SharePoint site varies based on the URL that you provided when you created the site collection. The URL of the SharePoint site may be: http://[SharePointServerName]:[PortNumber] -or- http://[SharePointServerName]:[PortNumber]/sites/[SiteName]

Configure Reporting Services 2012 or 2014 in SharePoint integrated mode

If you are using Reporting Services 2012 or 2014, follow these steps to configure Reporting Services in SharePoint integrated mode.

1. Configure Reporting Services by using the following topics in the SQL Server documentation:

   If you are using SharePoint 2010, see these topics:	If you are using SharePoint 2013, see these topics:
   Install Reporting Services SharePoint Mode for SharePoint 2010 Important When installing Reporting Services 2012 in SharePoint integrated mode, be sure that you do not mark the Reporting Services – Native option on the Feature Selection page of the SQL Server Setup Wizard. Add an Additional Report Server to a Farm (SSRS Scale-out) Add an Additional Reporting Services Web Front-end to a Farm	Install Reporting Services SharePoint Mode for SharePoint 2013 Important When installing Reporting Services 2012 in SharePoint integrated mode, be sure that you do not mark the Reporting Services – Native option on the Feature Selection page of the SQL Server Setup Wizard. Add an Additional Report Server to a Farm (SSRS Scale-out) Add an Additional Reporting Services Web Front-end to a Farm

2. If you did not create a site collection when installing and configuring SharePoint, create one now. If you are using SharePoint 2010, see the instructions here. If you are using SharePoint 2013, see the instructions here.

3. Verify that you can access the websites that are listed in the following table.

   Website	Default URL
   Reporting Services web service	The URL of the Reporting Services web service varies based on the URL that you provided when you created the site collection. The URL of the Reporting Services web service may be: http://[SharePointServerName]:[PortNumber]/_vti_bin/ReportServer -or- http://[SharePointServerName]:[PortNumber]/sites/[SiteName]/_vti_bin/ReportServer
   SharePoint site	The URL of the SharePoint site varies based on the URL that you provided when you created the site collection. The URL of the SharePoint site may be: http://[SharePointServerName]:[PortNumber] -or- http://[SharePointServerName]:[PortNumber]/sites/[SiteName]

   For more information about how to verify that the integration is configured correctly, see Verify a Reporting Services Installation in the SQL Server documentation.