How to install the Reporting Server on a Standalone Computer and Connect it to the Database
Applies to: Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, and Windows Server 2008 R2
Use the following procedure to install the reporting server on a standalone computer and connect it to the database.
Before performing the following procedure you should read and understand About App-V Reporting.
To install the reporting server on a standalone computer and connect it to the database
Copy the App-V server installation files to the computer on which you want to install it on. To start the App-V server installation right-click and run appv_server_setup.exe as an administrator. Click Install.
On the Getting Started page, review and accept the license terms, and click Next.
On the Use Microsoft Update to help keep your computer secure and up-to-date page, to enable Microsoft updates, select Use Microsoft Update when I check for updates (recommended). To disable Microsoft updates, select I don’t want to use Microsoft Update. Click Next.
On the Feature Selection page, select the Reporting Server checkbox and click Next.
On the Installation Location page, accept the default location and click Next.
On the Configure Existing Reporting Database page, select Use a remote SQL Server, and type the machine name of the computer running Microsoft SQL Server, for example SqlServerMachine.
If the Microsoft SQL Server is deployed on the same server, select Use local SQL Server. For the SQL Server Instance, select Use the default instance. If you are using a custom Microsoft SQL Server instance, you must select Use a custom instance and then type the name of the instance. Specify the SQL Server Database name that this reporting server will use, for example AppvReporting.
On the Configure Reporting Server Configuration page.
Specify the Website Name that you want to use for the Reporting Service. Leave the default unchanged if you do not have a custom name.
For the Port binding, specify a unique port number that will be used by App-V, for example 55555. You should also ensure that the port specified is not being used by another website.