Complete the following steps to configure Reporting Services. Reporting Services must be configured before you install the reporting extensions.
Keep in mind that if you chose to install Reporting Services in its default configuration, Reporting Services is already configured for you. We recommend that you complete the following steps to verify that options are configured correctly.
1. Open the Reporting Services configuration tool (Start > Programs > Microsoft SQL Server
> Configuration Tools > Reporting Services Configuration or Reporting Services Configuration Manager).
2. Select your Reporting Services instance and enter credentials to log on to the instance.
3. If you are using Reporting Services 2005, configure the following options. For detailed information about each option, see the SQL Server documentation.
Click this option… To do this…
Server Status Verify that Reporting Services is running. If it is not running, click Start.
Report Server Virtual Directory
Create a virtual directory for the Reporting Services Web service. By default, the virtual directory will be named ReportServer.
If this virtual directory is on a Web site that uses a port other than port 80, you must add an exception to Windows Firewall. For more information about Windows Firewall, see the Windows documentation.
Important:
If this virtual directory runs on the Default Web Site in IIS—and you later install Windows SharePoint Services or Microsoft Office SharePoint Server—the SharePoint installation program will stop the Default Web Site and create a new site that runs on port 80. This means you will have to configure the Default Web Site to run on a different port and restart the site.
Report Manager Virtual Directory
Create a virtual directory for Report Manager. (Report Manager is the Web site reports will be published to.) By default, the virtual directory will be named Reports.
If this virtual directory is on a Web site that uses a port other than port 80, you must add an exception to Windows Firewall. For more information about Windows Firewall, see the Windows documentation.
Important:
If this virtual directory runs on the Default Web Site in IIS—and you later install Windows SharePoint Services or Microsoft Office SharePoint Server—the SharePoint installation program will stop the Default Web Site and create a new site that runs on port 80. This means you will have to configure the Default Web Site to run on a different port and restart the site.
Windows Service Identity
Select the domain account you created to run the Reporting Services Windows service. For more information, see Create domain accounts.
Web Service Identity
Select an application pool for the Report Server virtual directory. By default, the DefaultAppPool application pool will be used.
Important:
You must later configure the Report Server virtual directory to use the AxReportServer application pool. For more information about configuring the virtual directory on Windows Server 2003, see Install the reporting extensions. For more information about configuring the virtual directory on Windows Server 2008, see Configure Reporting Services 2005 on Windows Server 2008.
Database Setup Create a database for Reporting Services. By default, this database will be named ReportServer.
SharePoint Integration
Do not configure Reporting Services to run in the SharePoint integrated mode.
Reporting Services must run in the native mode.
Encryption Keys Not required. For more information, see the SQL Server documentation.
Initialization Verify that the Reporting Services instance has been initialized.
Email Settings Not required. For more information, see the SQL Server documentation.
Execution Account Do not specify an execution account.
4. If you are using Reporting Services 2008, configure the following options. For detailed information about each option, see the SQL Server documentation.
Click this option… To do this…
ServerName/InstanceName Verify that Reporting Services is running. If it is not running, click Start.
Service Account Specify the account that is used as the .NET Business Connector proxy account.
Note:
To view the .NET Business Connector proxy account, go to your Microsoft Dynamics AX client and open the System service accounts form (Administration > Setup > Security >System service accounts).
Web Service URL Create a virtual directory for the Reporting Services Web service. By default, the virtual directory will be named ReportServer.
You can specify the port you want this virtual directory to use. However, if you specify a port other than port 80, you must add an exception to Windows Firewall. For more information about Windows Firewall, see the Windows documentation.
Database Create a database for Reporting Services. By default, this database will be named ReportServer.
Report Manager URL Create a virtual directory for Report Manager. (Report Manager is the Web site reports will be published to.) By default, the virtual directory will be named Reports.
You can specify the port you want this virtual directory to use. However, if you specify a port other than port 80, you must add an exception to Windows Firewall. For more information about Windows Firewall, see the Windows documentation.
E-mail Settings Not required. For more information, see the SQL Server documentation.
Execution Account Do not specify an execution account.
Encryption Keys Not required. For more information, see the SQL Server documentation.
Scale-out Deployment Not required. For more information, see the SQL Server documentation.
To access the Report Server virtual directory, use the following URL:
http://localhost/ReportServer
To access the Report Manager virtual directory, use the following URL:
http://localhost/Reports