App-V 5 and Office 2013 – Part 2: Component installation

In Part 2 of this App-V 5 guide, we will install the App-V Server Components which include Management, Reporting, and Publishing aspects.

Joseph MoodyMVP By Joseph Moody - Tue, February 26, 2013 - 7 comments google+ icon

Joseph Moody is an admin for a public school and helps manage 5,500 PCs. He is a Microsoft Most Valuable Professional (MVP) in Software Packaging, Distribution, and Servicing. He blogs at DeployHappiness.com.

Articles in this series

App-V 5 and Office 2013

Contents of this article
  1. Installing the servers

When setting up App-V, virtualized packages (.APPV files) can be deployed in a variety of ways. Because the package contents contain a MSI, Group Policy or System Center Configuration Manager can be used for installation. But where is the fun in that?

By using the App-V Servers for package management, you will gain some awesome and unique abilities. For example, some software may require restarts when deployed traditionally. When an App-V server is used, a restart is not required! This same benefit applies to an uninstall as well.

As a note, this walkthrough combines the App-V components for simplicity. Due to this, we will only configure two virtual servers. Larger environments may want to run redundant servers or to separate the components out onto specific servers.

Installing the servers

In part 1, we created three servers for our test domain. One of these servers, App-V, will host all of the server components. SQL-01, our other server, will host the two App-V database components. If needed, you can check the App-V 5.0 prerequisites here before proceeding.

First, we will need to setup the database components. If you haven’t installed SQL already, refer back to Part 1 for the SQL download and component selection.

To get started, simply execute the App-V 5 Setup.

App-V 5 initial setup

App-V 5 initial setup

Continue past the EULA and if desired, enable automatic updates for the server components.

As a best practice, enable Updates for App-V components.

As a best practice, enable Updates for App-V components.

On the server feature selection page, only check the options for the Management Server DB and Reporting Server DB.

Installing the databases on a dedicated SQL machine will be a common configuration for most organizations

Installing the databases on a dedicated SQL machine will be a common configuration for most organizations.

Continue through the wizard until you reach the database creation page. Once you are on the Database creation window, you can customize the SQL Server instance and Management Server database. For simplicity, I accepted the default values.

Management Server Database Creation

Management Server Database Creation

Proceed through the Reporting Server Database setup as well. I accepted the default values here. Continue until the Setup has finished.

The App-V database components successfully installed

The App-V database components successfully installed.

Because this guide configures App-V in a test environment, the SQL security best practices were followed. If you are interested in Microsoft’s Best Practices for App-V security, please see this guide.

Now that we are finished with SQL-01 (and the two App-V databases), let’s complete the installation of the App-V server components. Launch the setup and continue until you reach the feature selection window. Once there, select Management, Publishing and Reporting server.

As a note, the account running this setup must be able to modify the two SQL databases on SQL-01

As a note, the account running this setup must be able to modify the two SQL databases on SQL-01.

Because we previously created our SQL server, the App-V setup will completely configure the two databases. On the existing management Database window, enter your SQL server name and accept the other values.

Repeat these same steps for the Reporting Server

Repeat these same steps for the Reporting Server

Once finished, you will be presented with a link to access the management console.

Favorite the Management Console – it will make your life much easier

Helpful Hint: Favorite the Management Console – it will make your life much easier!

The Management Console has certainly been streamlined in version 5 and appears much like Server Manager for Windows Server 2012.

App-V 5 Management Console

App-V 5 Management Console

In my next post, we will setup our sequencer and package Office 2013. If you run into issues setting up your lab, let us know in the comments.

Series NavigationAPP-V 5 and Office 2013 – Part 1: Lab setup - App-V 5 and Office 2013 – Part 3: Packaging

-1+1 - Rate this post
Loading ... Loading ...
Disclaimer
Your question wasn't answered? Please ask in the new 4sysops forum!

7 Comments- Leave a Reply

  1. Chris says:

    So I have a Server 2012 Standard box with Sql Server 2012 SP1 installed per instructions on Part 1 (with just the Database Engine Services and Management Tools) but now when I start the DB install of APPv (the screen asking “Create New Management Server Database) I select the options “Default Instance” like you showed but I receive a message stating:
    “Cannot connect to the SQL instance you specified. Please make sure that it exists, the database server is running, and that you have the necessary access rights.”

    I did run as administrator on the install, I have ran a repair install of SQL Server 2012 to ensure the two options from Part 1 was selected, and verified the necessary services are running. Do you have any clues? Thanks again.

  2. chris says:

    Well, I can’t even log into the Sql Server Instance so something is fubar. Interesting as I never was asked nor setup a user name during the install. Interesting.

  3. Chris says:

    Sorry for the spam. So I reran the SQL Server install and had to select Mixed mode (Windows and Sql Authentication). Previously I had it setup for Windows Authentication but thats when errors appeared.

  4. Chris says:

    lol, if you don’t hate me yet you will soon enough. I finished the installation just fine but now when I open the Management Website I receive “There were problems interacting with the database on the server. The error was: Login failed for user ‘APPV\APP-V$’.”

    Not sure where that App-v user came from as that is not the account I entered during the setup asking me which account or group would have access to manage Appv. I gave it an account that has access to modify the SQL-01 server and instances.

  5. Joseph Moody says:

    Hi Chris,

    SQL can be such a pain! APPV\APP-V$ means SQL is using the local account.

    Are you running the database and management portion on the same machine?

  6. GUESS says:

    Hi Chris,

    This is an error I came accross and it took me two days to solve it.
    I did two steps but I think the step 1 is the solution.
    1) Use the domaine account(Admin of domain controller ) in the Application pool instead of Network service account.
    Make sure that the domain account is admin of the sql server machine.
    (Open IIS on the APPV server and locate the application pool of the website App,go to Advanced settings then change the identity to the domain controller admin account)

    2) this step is not useful-On the sql server, I have located the sql server service go to properties and change the network service to DC admin account.

    These are the two steps that helped me.
    I hope it clears your headache.
    Thank you

  7. Jono says:

    Thanks, this was the solution: “Open IIS on the APPV server and locate the application pool of the website App,go to Advanced settings then change the identity to the domain controller admin account”

Please share your thoughts in a comment!

Login

Lost your password?