Configuring MS SQL for the Parallels RAS Reporting Service

Share on FacebookTweet about this on TwitterShare on LinkedInShare on Google+Email this to someonePrint this pagePin on PinterestShare on TumblrBuffer this pageShare on RedditShare on StumbleUpon


This article describes the new and comprehensive reporting feature.

Parallels RAS Reporting – Overview

Parallels RAS empowers users to access their business apps from any major platform. Every time a user connects to the system, Parallels RAS gathers important data about user preferences, active periods, idle periods, and resources utilized to support the connection.

Data are of paramount importance to administrators, because analytical capabilities support management in decision-making.Parallels has identified this need, and has integrated a reporting engine in Parallels RAS. This reporting engine is capable of providing information that helps administrators adjust systems for better performance and efficiency. Support users in a pre-emptive manner, by detecting and preventing bottlenecks before they escalate into issues, rather than dealing with outages as they arise. You can also analyse how your users are interacting with the system and extract important information that helps management make the right decisions.

Parallels RAS Reporting – Reporting Setup

Parallels Reporting leverages MS SQL reporting services to generate and display information collected from Terminal Servers in theParallels RAS console. Before you can generate reports, MS SQL and the Parallels Reporting Service must be installed and configured, either on the same machine as Parallels RAS, or preferably a different machine running within the same network.

2X RAS Reporting 1

With MS SQL installed and configured, the Parallels Reporting Service can be installed on the MS SQL machine to deploy the database schema required. Subsequently, Parallels RAS should be configured to communicate with the SQL server, at which point reporting is completely operational.

2X RAS Reporting 2

For the full MS SQL installation and configuration step-by-step procedure recommended by Parallels, please review the manual here.

Parallels RAS Reporting – The Reporting Interface

The Parallels Reporting Service provides a number of reports accessible from the Parallels RAS console, 14 in total, categorized into five groups.

2X RAS Reporting 3

The User Reports group provides insight into how end users are interacting with Parallels RAS. Group Reports indicate how groups of users are interacting with the system. The Devices Reports yields information about the devices that are connecting to Parallels RAS. Server Reports generate Parallels RAS server component usage statistics including server health, showing CPU and RAM usage in a graph. Lastly, generate Application Reports to learn which applications are being used.

Sean Bianco is the marketing documentalist and technical writer at Parallels. With a bachelor’s degree in Information Technology and Networking and a three year background in software quality assurance testing and usability engineering, Sean is a subject matter expert in mobility and smartphone, app and device management. He is well-versed in developing technical articles and determining market trends. His excellent analytical and problem-solving skills, with emphasis on understanding relationships between technical problems, result in sound and effective business solutions.

  • chuck keith

    UPD work in a 2008 R2 environment?

    • Improved RDP connection reliability on Windows clients using UDP protocol tunneling for better performance, even with a slow connection or high latency.

    • Giorgio Bonuccelli, Marketing Director

      HI Chuck, thanks for your question. Yes It works also on 2008 R2.