Deploy and Configure RAS Reports

To use the reporting functionality, you need to install and configure MS SQL Server and the RAS Reporting Service. Before doing so, first check whether your server complies with the prerequisites outlined below. Once confirmed, proceed with the installation and configuration process.

Environment Requirements

1. A machine running Windows Server 2008, Windows Server 2008 R2, Windows Server 2012 or Windows Server 2012 R2
2. To view RAS reports, a default AD user account will be created by the RAS Reporting installation process. The account name is RASREPORTINGVIEW.
3. Microsoft SQL Server 2008 SP1, Microsoft SQL Server 2008 R2 SP1 or Microsoft SQL Server 2012 - You are required to have a database instance installed either on the same machine running Parallels Remote Application Server or a different machine running within your network.

SQL Server Configuration Requirements

1. MS SQL Server features installed: Database Engine Services, Reporting Services - Native, Management Tools.
2. MS SQL Named Instance: RASREPORTING, Instance ID: RASREPORTING
3. SQL Server Administrators - SA (System Administrator), AD Administrator, System User.
4. SQL Server Reporting Services (SSRS) port set to 8085.

For the full step-by-step recommended MS SQL installation and configuration procedure, please read the following KB article: http://kb.parallels.com/en/123083

Note: For installations running on a multi-server farm environment, it is recommended that MS SQL Server is installed on a dedicated machine.

Installing RAS Reporting

Log in to the machine running MS SQL Server with an account that has administrative privileges (AD).

1. Download the latest version of the RAS Reporting setup from http://download.parallels.com/ras/v15/RASReporting.msi
2. Double-click RASReporting.msi to run the installation wizard.
3. Click Next when prompted.
4. Review and approve the end-user license agreement and click Next.
5. Specify the target folder for the installation and click Next.
6. Click Install to commit the config and initiate the installation.
7. Click Finish.

Configure Reporting in the RAS Console

To configure RAS Reporting:

1. Select the Administration category in the RAS Console and then click the Reporting tab in the right pane.
2. On the Reporting tab page, specify the following options:
   • Select the Enable RAS Reporting option to enable the RAS reporting functionality.
   • Server. Specify the IP address of the server hosting your SQL Server database where the Reporting service is installed. If the database is located on the same machine where you have Mobile Device Management installed, you can use localhost.
   • Port. Specify the port used to communicate with the Reporting service.
   • Prompt user for Login Details. Will prompt the user for AD credentials when generating reports.
   • Use following credentials. Specify AD username and password to be used each time a report is generated
3. When done, click the Test Connection button to test the configuration.
4. Click Apply to commit the configuration.

Note: The default user RASREPORTINGVIEW is created during the installation process. Alternate users need to be configured in SSRS with browser permissions.