Before you can generate reports from the Remote Application Server console, MS SQL and the Reporting Service must be installed and configured. Before doing so, first check whether your machine complies with the prerequisites outlined below. Once confirmed, proceed with the 3 stage process: MS SQL installation and configuration, Reporting Services installation and Remote Application Server configuration.
Supported operating systems: A machine running Windows Server 2008, Windows Server 2008 R2, Windows Server 2012 or Windows Server 2012 R2 with .Net 4.5 installed.
Database Engine: Microsoft SQL Server 2012 Express, SQL Server 2008 R2 Service Pack 1, SP2 and SP3.
Note: On farm environments with multiple terminal or vdi servers it is recommended that MS SQL is installed on a dedicated machine.
Active Directory User Requirements: To View reports, a user must be created in the Active Directory with the following credentials:
- Username: RASREPORTINGVIEW
Stage 1: Installing MS SQL
Reporting requires a database instance installed either on the same machine running Parallels Remote Application Server or recommended on a different machine running within the Remote Application Server local network.
Run the SQL Server setup file > Installation. Select New SQL Server stand-alone installation or add features to an existing installation to launch the setup.
The Setup Support Rules page will attempt to identify any issues during the SQL Server Setup Support Files installation. Upon completion, click Next to continue.
Enter the product license key, click Next and accept the license terms to continue to the Setup Role dialog.
Next, select SQL Server Feature Installation and click Next.
Next, enable the features listed below that are required for reporting and click Next to continue:
- Database Engine Services
- Reporting Services – Native
- Management Tools
Reporting Services requires that the SQL server has been configured using a specific named instance.
From the Instance Configuration page, select the option Named instance,input the information below and click Next to continue:
- Named Instance:RASREPORTING
- Instance ID:RASREPORTING
Without the named instance above, Reporting setup will not complete.
Subsequently, the Disk Space Requirements and Server Configuration dialogs are shown. Confirm the information and click the Next button to proceed.
In the Database Engine Configuration window select Windows authentication mode and add the users below as SQL Server administrators:
- Systems Administrator
- AD Administrator
- System User
The next step introduces the Reporting Service Configuration that is used to by Remote Application Server to generate reports. Select the Install and configure option click Next to continue.
In the Ready to install section, ensure that:
- Features to be installed include:
- Database Engine
- Reporting Services
- Management Studio Tools
- Instance Name
- MUST BE: RASREPORTING
Once confirmed, click Install to proceed with the installation. Upon completion, proceed to the verification process and port setup procedures.
- Features to be installed include:
Next, verify that reporting services have been set up correctly. Open the Reporting Services Configuration Manager.
Input the server name from the Report Server Instance dropdown, select RASREPORTING and click Connect.
Verify that the Report Service Status = Started.
Verify the Web Service URL is set to: ReportServer_RASREPORTING.
- Next change the SQL Reporting Services default port to 8085, in order to avoid conflicts between Remote Application Server gateways and SSRS (port 80), according to the procedure mentioned in KB 123634.
Stage 2: Reporting Setup
At this stage you will proceed to install Remote Application Server Reporting Services. Log in to the machine running MS SQL with an account that has administrative privileges (AD) and proceed to install reports.
Download the latest version of the RAS Reporting Service setup from the Download webpage.
Double-click 2XRASReporting.msi setup file to run the installation wizard. Click Next when prompted. Review and approve the end-user license agreement and click Next.
Specify the folder location where Remote Application Server will be installed, click Next and then Install to commit the config and initiate installation.
You have successfully installed Remote Application Server Reporting. Click Finish to complete the installation.
Stage 3: Configuration on Remote Application Server Management Console
Reports are generated from the Remote Application Server Console. To generate reports Remote Application Server must be configured to communicate with the reporting service.
Configure reporting from the Remote Application Server Console > Administration > Reporting. Click the Reporting Engine dropdown and select Reporting.
- Server: Specify the IP address of the machine hosting your SQL database that the Reporting service is installed on. If the database is located on the same machine you have installed Remote Application Server on, you can also use localhost.
- Port: Specify the port used to communicate with the Reporting service.
- Prompt user for Login Details – If selected, will prompt the user for AD credentials when generating reports.
- Use following credentials: If selected, specify AD username and password to be used each time a report is generated.
Subsequently click Test Connection to test the configuration and Apply to commit the configuration.
Note: The default user for viewing reports RASREPORTINGVIEW must be created before RAS Reporting installation. Alternate users need to be configured in SSRS with browser permissions.
Viewing the reports
After the configuration is complete and credentials are verified via the test button, switch to the Reporting category to generate and view the reports. Note that the first time you view reports you may be requested to add http://