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
-
A machine running Windows Server 2008, Windows Server 2008 R2, Windows Server 2012 or Windows Server 2012 R2
-
To view RAS reports, a default AD user account will be created by the RAS Reporting installation process. The account name is
RASREPORTINGVIEW
. You can specify a different user during the RAS Reporting setup if you wish.
-
Microsoft SQL Server 2008 SP1, Microsoft SQL Server 2008 R2 SP1 or Microsoft SQL Server 2012 installed on a server running Parallels RAS or a dedicated server.
SQL Server Configuration Requirements
-
SQL Server features installed: Database Engine Services, Reporting Services: Native, Management Tools.
-
SQL Server Named Instance: the default name that the RAS Reporting installer uses is RASREPORTING, Instance ID: RASREPORTING. You can specify a different name during the RAS Reporting setup if you wish.
-
SQL Server Administrators - SA (System Administrator), AD Administrator, System User.
-
SQL Server Reporting Services (SSRS) port set to 8085.
For the full step-by-step recommended Microsoft SQL Server installation and configuration, 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 Microsoft 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).
-
Download the latest version of the RAS Reporting setup from
http://download.parallels.com/ras/v15.5/RASReporting.msi
-
Double-click
RASReporting.msi
to run the installation wizard.
-
Click
Next
when prompted.
-
Review and approve the end-user license agreement and click
Next
.
-
Specify the target folder for the installation and click
Next
.
-
Specify the SQL Server named instance name. The default instance is RASREPORTING. If you would like to use a different instance, you can specify it on this page. If the instance doesn't exist, you need to create it first.
-
Specify the user who will be allowed to view reports. The default user is RASREPORTINGVIEW. If you would like to use a different user, you can specify it on this page. If the user doesn't exist, you need to create it first.
-
Click
Install.
-
When the installation is complete, click
Finish
.
Configure Reporting in the RAS Console
To configure RAS Reporting:
-
Select the
Administration
category in the RAS Console and then click the
Reporting
tab in the right pane.
-
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.
-
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. The default user name is
RASREPORTINGVIEW
. If you specified a different user when you installed the RAS Reporting module, you can use that user name.
-
When done, click the
Test Connection
button to test the configuration.
-
Click
Apply
to commit the configuration.
|