App-V 5.0 Reporting Server, missing prerequisites

Written by Ingmar Verheij on October 10th, 2013. Posted in Application Virtualization

Microsoft App-V 5.0During a Microsoft App-V 5.0 implementation I had to deploy an App-V Reporting server so the customer could track usage information. I found that the required information is not well documented at TechNet but can be found (it’s scattered around the internet). Also, the information provided by Microsoft is (at the moment of writing) not accurate. Prerequisites are missing.

Hence I figured it would be good to sum up the information I gathered along the way.

Prerequisites

Before you can (or should) install the App-V 5.0 Reporting Server certain prerequisites should be met. I won’t sum there here as they are summed at the TechNet Library. Unfortunately not all prerequisites are clear or missing.

Server

  • App-V 5.0 Reporting Server PrerequisitesOn Windows Server 2012 you need to install .ASP.NET 4.5  (not ASP.NET 3.5).This makes sense since .NET Framework 4 a perquisite. The same applies for .NET Extensibility
  • Besides the x86 version of the Microsoft Visual C++ 2010 SP1 Redistributable Package you also need the x64 version. This makes sense since the 64-bit ASP.NET registration is requested.

When Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) is NOT installed you’ll receive the following error on the App-V 5.0 Client: AppV Error Code: 1300000013. Additionally an error event is raised on the client by Microsoft-AppV-Client/Admin with ID 17006. On the App-V Reporting Server a warning event is raised by ASP.NET 4.0.30139.0 with ID 1310.

Send-AppvClientReport : No reporting data has been sent to the specified URL. Verify the URL and try again. Operation attempted: Send reporting data to reporting server.

Event 17006, Microsoft-AppV-Client-Admin Event 1310, ASP.NET 4.0.30319.0

 

Database

  • The computer account of the App-V Reporting Servers requires a SQL login with sufficient (dbOwner?) privileges on the AppVReporting database. Unlike with the Management database you can’t nest the computer account in an Active Directory Group (AppVRead / AppVWrite / AppVAdmins).

When the computer account has no SQL login an Error event is raised by Server-Reporting with ID 100.SQL Server Profiler

Event 100, Server-Reporting

Login - New

 

Client configuration

After the Microsoft App-V Reporting server is built and configured the App-V client needs to be configured to upload its usage data. On each App-V Client you need to run the Set-AppvClientConfiguration cmdlet with –ReportingEnabled 1 parameter, more details can at the TechNet Library.

 

Others

You need to keep the following in mind:

  • Each App-V Client communicates directly with the Reporting Server, this is not handled by the Publishing Server;
  • Collected data from the App-V client is processed once a day at midnight (for details see hakabo.com);
  • Microsoft does not provided reports or software to display reports.

Yes you’ve read the last one correct, Microsoft does not supply any mechanism to display the tracked usage of the App-V applications. While the Management Server console looks pretty awesome it’s very basic. So what if you want to create reports based on the collected data? Well, that’s up to you. At hakabo.com you can find an example how create reports using Microsoft Excel or SQL Reporting Services.

 

Conclusion

While Microsoft made a lot of improvements with App-V 5.0, the first complete rebuild since the initial release (Softricity SoftGrid). But the documentation is poor and incomplete, which is a shame.

 

 

.

Ingmar Verheij

At the time Ingmar wrote this article he worked for PepperByte as a Senior Consultant (up to May 2014). His work consisted of designing, migrating and troubleshooting Microsoft and Citrix infrastructures. He was working with technologies like Microsoft RDS, user environment management and (performance) monitoring. Ingmar is User Group leader of the Dutch Citrix User Group (DuCUG). RES Software named Ingmar RES Software Valued Professional in 2014.

More Posts - Website

Follow Me:
TwitterLinkedInGoogle Plus

Tags: , ,

Trackback from your site.

Comments (5)

  • Ruben Duron
    6 December 2013 at 00:31 |

    I am getting the same powershell error in my environment. I have a question do you have the Reporting server on the same server as SQL? I checked my SQL server which is separate from the reporting server and it is missing the prerequisite you mention. Thank you

    • Ingmar Verheij+
      9 December 2013 at 14:01 |

      I have a separate server for the SQL Reporting Service, it’s on the same box as the App-V Reporting Server.
      There is no need to add the prerequisite on the SQL server.

      • Ruben Duron
        4 January 2014 at 00:10 |

        Thanks for your help. Is your SQL server Windows Server 2008 or 2012?

        • Ingmar Verheij+
          4 January 2014 at 10:11 |

          The SQL Server is 2008R2, the SQL Reporting Server is 2012.

Leave a comment

*

Donate

%d bloggers like this: