{"id":5650,"date":"2013-10-10T16:52:06","date_gmt":"2013-10-10T14:52:06","guid":{"rendered":"https:\/\/ingmarverheij.com\/?p=5650"},"modified":"2013-10-11T15:53:15","modified_gmt":"2013-10-11T13:53:15","slug":"app-v-5-0-reporting-server-missing-prerequisites","status":"publish","type":"post","link":"https:\/\/ingmarverheij.com\/en\/app-v-5-0-reporting-server-missing-prerequisites\/","title":{"rendered":"App-V 5.0 Reporting Server, missing prerequisites"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" title=\"Microsoft App-V 5.0\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: right; padding-top: 0px; padding-left: 0px; margin: 0px 0px 0px 5px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Microsoft App-V 5.0\" align=\"right\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Microsoft-App-V-5.0.png\" width=\"120\" height=\"117\" \/>During a Microsoft App-V 5.0 implementation I had to deploy an App-V <strong>Reporting server <\/strong>so the customer could track <strong>usage <\/strong>information. I found that the required information is not well documented at TechNet but can be found (it\u2019s scattered around the internet). Also, the information provided by Microsoft is (at the moment of writing) not accurate. Prerequisites are missing. <\/p>\n<p>Hence I figured it would be good to sum up the information I gathered along the way.<\/p>\n<p><!--more--><\/p>\n<h1>Prerequisites<\/h1>\n<p>Before you can (or should) install the App-V 5.0 Reporting Server certain prerequisites should be met. I won\u2019t sum there here as they are summed at the <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/jj713458.aspx\" target=\"_blank\">TechNet Library<\/a>. Unfortunately not all prerequisites are clear or missing.<\/p>\n<h4>Server<\/h4>\n<ul>\n<li><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/App-V-5.0-Reporting-Server-Prerequisites.png\"><img loading=\"lazy\" decoding=\"async\" title=\"App-V 5.0 Reporting Server Prerequisites\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: right; padding-top: 0px; padding-left: 0px; margin: 0px 0px 0px 5px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"App-V 5.0 Reporting Server Prerequisites\" align=\"right\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/App-V-5.0-Reporting-Server-Prerequisites_thumb.png\" width=\"154\" height=\"119\" \/><\/a>On Windows Server 2012 you need to install .<strong>ASP.NET 4.5&#160; (<\/strong>not ASP.NET 3.5).This makes sense since .NET Framework 4 a perquisite. The same applies for .NET Extensibility <\/li>\n<li>Besides the x86 version of the <strong>Microsoft Visual C++ 2010 SP1 Redistributable Package <\/strong>you also need the <strong><a href=\"https:\/\/www.google.nl\/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;ved=0CDEQFjAA&amp;url=http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D13523&amp;ei=C7hWUvfOJpGg7AasgYG4Dg&amp;usg=AFQjCNG6J7CQIwDZDisBA_z6ANojoO0frw&amp;bvm=bv.53760139,d.ZGU\" target=\"_blank\">x64<\/a> <\/strong>version. This makes sense since the 64-bit ASP.NET registration is requested. <\/li>\n<\/ul>\n<p>When <a href=\"https:\/\/www.google.nl\/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;source=web&amp;cd=1&amp;cad=rja&amp;ved=0CDEQFjAA&amp;url=http%3A%2F%2Fwww.microsoft.com%2Fen-us%2Fdownload%2Fdetails.aspx%3Fid%3D13523&amp;ei=C7hWUvfOJpGg7AasgYG4Dg&amp;usg=AFQjCNG6J7CQIwDZDisBA_z6ANojoO0frw&amp;bvm=bv.53760139,d.ZGU\" target=\"_blank\">Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)<\/a> is NOT installed you\u2019ll receive the following error on the App-V 5.0 Client: <font face=\"Courier New\"><strong><font face=\"Arial\">AppV Error Code: 1300000013<\/font><\/strong>. <\/font><font face=\"Arial\">Additionally an <strong>error<\/strong> event is raised on the client by <strong>Microsoft-AppV-Client\/Admin<\/strong> with ID <strong>17006. <\/strong>On the App-V Reporting Server a <strong>warning<\/strong> event is raised by <strong>ASP.NET 4.0.30139.0<\/strong> with ID <strong>1310<\/strong>.<\/font><\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Send-AppvClientReport-No-reporting-data-has-been-sent-to-the-specified-URL.-Verify-the-URL-and.png\"><img loading=\"lazy\" decoding=\"async\" title=\"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.\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"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.\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Send-AppvClientReport-No-reporting-data-has-been-sent-to-the-specified-URL.-Verify-the-URL-and1.png\" width=\"314\" height=\"50\" \/><\/a><\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-17006-Microsoft-AppV-Client-Admin-.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Event 17006, Microsoft-AppV-Client-Admin \" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Event 17006, Microsoft-AppV-Client-Admin \" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-17006-Microsoft-AppV-Client-Admin-_thumb.png\" width=\"154\" height=\"108\" \/><\/a><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-1310-ASP.NET-4.0.30319.0.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Event 1310, ASP.NET 4.0.30319.0\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Event 1310, ASP.NET 4.0.30319.0\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-1310-ASP.NET-4.0.30319.0_thumb.png\" width=\"154\" height=\"107\" \/><\/a><\/p>\n<h4>&#160;<\/h4>\n<h4>Database<\/h4>\n<ul>\n<li>The <strong>computer account <\/strong>of the App-V Reporting Servers requires a <strong>SQL login <\/strong>with sufficient (dbOwner?) privileges on the <strong>AppVReporting<\/strong> database. Unlike with the Management database you can\u2019t nest the computer account in an Active Directory Group (AppVRead \/ AppVWrite \/ AppVAdmins). <\/li>\n<\/ul>\n<p>When the computer account has no SQL login an Error event is raised by <strong>Server-Reporting <\/strong>with ID <strong>100.<a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/SQL-Server-Profiler.png\"><img loading=\"lazy\" decoding=\"async\" title=\"SQL Server Profiler\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"SQL Server Profiler\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/SQL-Server-Profiler_thumb.png\" width=\"279\" height=\"66\" \/><\/a><\/strong><\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-100-Server-Reporting.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Event 100, Server-Reporting\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; float: left; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Event 100, Server-Reporting\" align=\"left\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Event-100-Server-Reporting_thumb.png\" width=\"154\" height=\"108\" \/><\/a><\/p>\n<p><a href=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Login-New.png\"><img loading=\"lazy\" decoding=\"async\" title=\"Login - New\" style=\"border-left-width: 0px; border-right-width: 0px; background-image: none; border-bottom-width: 0px; padding-top: 0px; padding-left: 0px; margin: 0px 5px 0px 0px; display: inline; padding-right: 0px; border-top-width: 0px\" border=\"0\" alt=\"Login - New\" src=\"https:\/\/ingmarverheij.com\/wp-content\/uploads\/2013\/10\/Login-New_thumb.png\" width=\"120\" height=\"108\" \/><\/a><\/p>\n<p>&#160;<\/p>\n<h1>Client configuration<\/h1>\n<p>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 <strong>Set-AppvClientConfiguration<\/strong> cmdlet with <strong>\u2013ReportingEnabled 1 <\/strong>parameter, more details can at the <a href=\"https:\/\/technet.microsoft.com\/en-us\/library\/jj684297.aspx\" target=\"_blank\">TechNet Library<\/a>.<\/p>\n<p>&#160;<\/p>\n<h1>Others<\/h1>\n<p>You need to keep the following in mind:<\/p>\n<ul>\n<li>Each App-V Client communicates directly with the Reporting Server, this is <strong><em>not<\/em><\/strong> handled by the Publishing Server;<\/li>\n<li>Collected data from the App-V client is processed once a day at midnight (for details see <a href=\"https:\/\/www.hakabo.com\/web\/2012\/12\/app-v-5-reporting-setup-query-part-1\/\" target=\"_blank\">hakabo.com<\/a>);<\/li>\n<li>Microsoft does not provided reports or software to display reports.<\/li>\n<\/ul>\n<p>Yes you\u2019ve read the last one correct, Microsoft does <strong><em>not<\/em><\/strong> supply any mechanism to display the tracked usage of the App-V applications. While the Management Server console looks pretty awesome it\u2019s very basic. So what if you want to create reports based on the collected data? Well, that\u2019s up to you. At <a href=\"https:\/\/www.hakabo.com\/web\/2012\/12\/app-v-5-reporting-setup-query-part-2\/\" target=\"_blank\">hakabo.com<\/a> you can find an example how create reports using Microsoft Excel or SQL Reporting Services.<\/p>\n<p>&#160;<\/p>\n<h1>Conclusion<\/h1>\n<p>While Microsoft made a lot of improvements with App-V 5.0, the first complete rebuild since the initial release (<a href=\"https:\/\/en.wikipedia.org\/wiki\/Microsoft_App-V\" target=\"_blank\">Softricity SoftGrid<\/a>). But the documentation is poor and incomplete, which is a shame.<\/p>\n<p>&#160;<\/p>\n<p>&#160;<\/p>\n<p>.<\/p>","protected":false},"excerpt":{"rendered":"<p>During 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\u2019s scattered around the internet). Also, the information provided by Microsoft is (at the moment of writing) not [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[293],"tags":[599,600,601],"class_list":["post-5650","post","type-post","status-publish","format-standard","hentry","category-application-virtualization","tag-app-v","tag-application-virtualisation","tag-prerequisites"],"_links":{"self":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5650","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/comments?post=5650"}],"version-history":[{"count":3,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5650\/revisions"}],"predecessor-version":[{"id":5654,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/posts\/5650\/revisions\/5654"}],"wp:attachment":[{"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/media?parent=5650"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/categories?post=5650"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ingmarverheij.com\/en\/wp-json\/wp\/v2\/tags?post=5650"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}