Install the Management and Reporting Databases on Separate Computers from the Management and Reporting Services
Use the following procedure to install the database server and management server on different computers. The computer you plan to install the database server on must be running a supported version of Microsoft SQL or the installation will fail.
Note After you complete the deployment, the Microsoft SQL Server name, instance name and database name will be required by the administrator installing the service to be able to connect to these databases.
To install the management database and the management server on separate computers
Copy the App-V 5.0 server installation files to the computer on which you want to install it on. To start the App-V 5.0 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 components you want to install by selecting the Management Server Database checkbox and click Next.
On the Installation Location page, accept the default location and click Next.
On the initial Create New Management Server Database page, accept the default selections if appropriate, and click Next.
If you are using a custom SQL Server instance, then select Use a custom instance and type the name of the instance.
If you are using a custom database name, then select Custom configuration and type the database name.
On the next Create New Management Server Database page, select Use a remote computer, and type the remote machine account using the following format: Domain\MachineAccount.
Note If you plan to deploy the management server on the same computer you must select Use this local computer.
Specify the user name for the management server Install Administrator using the following format: Domain\AdministratorLoginName. Click Next.
- To start the installation, click Install.
To install the reporting database and the reporting server on separate computers
Copy the App-V 5.0 server installation files to the computer on which you want to install it on. To start the App-V 5.0 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 components you want to install by selecting the Reporting Server Database checkbox and click Next.
On the Installation Location page, accept the default location and click Next.
On the initial Create New Reporting Server Database page, accept the default selections if appropriate, and click Next.
If you are using a custom SQL Server instance, then select Use a custom instance and type the name of the instance.
If you are using a custom database name, then select Custom configuration and type the database name.
On the next Create New Reporting Server Database page, select Use a remote computer, and type the remote machine account using the following format: Domain\MachineAccount.
Note If you plan to deploy the reporting server on the same computer you must select Use this local computer.
Specify the user name for the reporting server Install Administrator using the following format: Domain\AdministratorLoginName. Click Next.
- To start the installation, click Install.
To install the management and reporting databases using App-V 5.0 database scripts
Copy the App-V 5.0 server installation files to the computer on which you want to install it on.
To extract the App-V 5.0 database scripts, open a command prompt and specify the location where the installation files are saved and run the following command:
appv_server_setup.exe /LAYOUT /LAYOUTDIR=”InstallationExtractionLocation”.
After the extraction has been completed, to access the App-V 5.0 database scripts and instructions readme file:
The App-V 5.0 Management Database scripts and instructions readme are located in the following folder: InstallationExtractionLocation \ Database Scripts \ Management Database.
The App-V 5.0 Reporting Database scripts and instructions readme are located in the following folder: InstallationExtractionLocation \ Database Scripts \ Reporting Database.
For each database, copy the scripts to a share and modify them following the instructions in the readme file.
Note For more information about modifying the required SIDs contained in the scripts see, How to Install the App-V Databases and Convert the Associated Security Identifiers by Using PowerShell.
Run the scripts on the computer running Microsoft SQL Server.
Got an App-V issue? Use the App-V TechNet Forum.