Installing Microsoft App-V 5.1 on Windows Server 2016

Pre-Requisites Tasks

Step 1: Create the following Active Directory Groups:-

• GRP-LABAPPVADMINS  – Group for adding AppV Admins for delegated access to Management Console website
• GRP-LABAPPVSERVERS – Group for adding Computer Accounts of the Management Servers

Step 2: Obtain the SID for the Groups by following the below instructions

Use the following PowerShell Command to retrieve the SID of the Admin & Server Security Group (required later in the document)

$account = "LAB\GRP-LABAPPVADMINS"
(New-Object system.security.principal.NtAccount($Account)).translate([system.security.principal.securityidentifier]).value

Note the Output

S-1-5-21-1368237551-799631787-4230672224-1137

Remove S and all Hyphens

1521136823755179963178742306722241137

 

$account = "LAB\GRP-LABAPPVSERVERS"
(New-Object system.security.principal.NtAccount($Account)).translate([system.security.princip

 

Note the Output

S-1-5-21-1368237551-799631787-4230672224-1139

Remove S and all Hyphens

1521136823755179963178742306722241139

Step 3: Obtain the ISO SW_CD_App_V_CAL_for_RDS_5.1_MultiLang_MLF_X20-35799.ISO, Browse Open APP-V SERVER 5.1 Folder

Run the following in Command Prompt “appv_server_setup.exe /Layout /LayoutDir=C:\Temp\Layout”

Step 4: Verify SQL Scripts are extracted to C:\temp\layout\DatabaseScripts\ManagementDatabase & C:\temp\layout\DatabaseScripts\ReportingDatabase

Step 5: Update the following SQL Scripts

As per https://support.microsoft.com/en-us/kb/3031340, the following scripts need to be updated due to mistakes

• InsertVersionInfo.sql
  • Change  Line from:

  • INSERT INTO dbo.SchemaChanges VALUES(@dbversion, @minserviceversion)

  • Change Line To

  • INSERT INTO dbo.SchemaVersion VALUES(2)

• Permissions.sql
  • Change Line from:

  • GRANT SELECT ON dbo.SchemaChanges TO PUBLIC

  • Change Line to:

  • GRANT SELECT ON dbo.SchemaVersion TO PUBLIC

 

Step 6: Update Permission.sql:

• [ManagementDbPublicAccessAccountSid] –>1521136823755179963178742306722241137
• [ManagementDbPublicAccessAccountName] –> LAB\GRP-LABAPPVADMINS

The script line should look like the following:-

/* Setting up server login and db login for read-access to SchemaChanges table */
EXEC dbo.spSetupLogin 0x1521136823755179963178742306722241137, N'LAB\GRP-LABAPPVADMINS', 0
GO

• [ManagementDbWriteAccessAccountSid] –>1521136823755179963178742306722241139
• [ManagementDbWriteAccessAccountName] –> LAB\GRP-LABAPPVSERVERS

The script line should look like the following:-

/* Setting up server login, db login and db roles for write-access to AppVManagement database */
EXEC dbo.spSetupLogin 0x1521136823755179963178742306722241139, N'LAB\GRP-LABAPPVSERVERS', 1
GO

Step 7: Launch SQL Server Management Studio on your SQL Server

Step 8: Run the Database.sql Script against the “master” database.

Step 9: Run the CreateTables.sql Script against the “AppVManagement” Database

Step 10: Repeat Step 7 against the AppVManagement Database for the following scripts in order listed below:

• CreateStoredProcs.sql
• UpdateTables.sql
• InsertVersionInfo.sql
• Permissions.sql

Step 11: Update Permission.sql found under C:\temp\layout\DatabaseScripts\ReportingDatabase

• [ReportingDbPublicAccessAccountSid] –>1521136823755179963178742306722241137
• [ReportingDbPublicAccessAccountName] –> LAB\GRP-LABAPPVADMINS

/* Setting up server login and db login for read-access to SchemaChanges table */
EXEC dbo.spSetupLogin 0x1521136823755179963178742306722241137, N'LAB\GRP-LABAPPVADMINS', 0
GO

• [ReportingDbPublicAccessAccountSid] –> 1521136823755179963178742306722241139
• [ReportingDbWriteAccessAccountName] –> LAB\GRP-LABAPPVSERVERS

/* Setting up server login, db login and db roles for write-access to AppVReporting database */
EXEC dbo.spSetupLogin 0x1521136823755179963178742306722241139, N'LAB\GRP-LABAPPVSERVERS', 1
GO

Step 12: Launch SQL Server Management Studio on your SQL Server

Step 13: Run the Database.sql Script against the “master” database.

Step 14: Run the UpgradeDatabase.sql Script against the “AppVReporting” Database

Step 15: Repeat Step 12 against the AppVReporting Database for the following scripts in order listed below:

• CreateTables.sql
• CreateReportingStoredProcs.sql
• CreateStoredProcs.sql
• CreateViews.sql
• InsertVersionInfo.sql
• Permissions.sql
• ScheduleReportingJob.sql

Step 16: Run the following command in Powershell (run as administrator) to install AppV 5.1 Windows Features required for Installation.

Add-WindowsFeature -Name "Web-Static-Content","Web-Default-Doc","Web-Asp-Net45","Web-Net-Ext45","Web-ISAPI-Ext","Web-ISAPI-Filter","Web-Windows-Auth","Web-Filtering","Web-Mgmt-Console","Web-Scripting-Tools"

Step 7: Confirm successful Installation

 

Install AppV 5.1 Management Server

Step 1: Attach ISO SW_CD_App_V_CAL_for_RDS_5.1_MultiLang_MLF_X20-35799.ISO, Open APP-V SERVER 5.1 Folder

 

Step 2: Right Click appv_server_setup, choose Run as administrator

Step 3: Microsoft Application Virtualization splash screen will appear

Step 4: Click Install at Setup Screen

Step 5: Select i accept the license terms, Click Next

Step 6: Select i don’t want to use microsoft update. Click Next

Step 7: Select Management Server/Publishing Server/Reporting Server Options. Click Next

Step 8: At Select Installation Location, leave as default. Click Next

Step 9: At Existing Management Database, enter the below information and Click Next

• SQL Server Name: Remote SQL Server Name:   LAB-SQL
• SQL Server Instance:  Use the default Instance
• SQL Server Database Name : AppVManagement

Step 10: At Existing Reporting Database, enter the below information and Click Next

• SQL Server Name: Remote SQL Server Name:   LAB-SQL
• SQL Server Instance:  Use the default Instance
• SQL Server Database Name : AppVReporting

Step 11: At Management Server Configuration, enter the below information and Click Next

• AD Group for Managing App-V: LAB\GRP-LABAPPVADMINS
• Website name : leave as default
• Port Binding: 50001

Step 12: At Publishing Server Configuration, enter the below information and Click Next

• Specify Management Service: leave as default
• Website name : leave as default
• Port Binding: 50002

Step 13: At Reporting Server Configuration, enter the below information and Click Next

• Website name : leave as default
• Port Binding: 50003

Step 14: At Ready for Installation. Click Install

Step 15: Installation will proceed with overall progress bar shown

Step 16: Installation will finish. Click Close

Step 17: Reboot the Server

Step 18: Log back into server launch http://localhost:50001 and confirm Management Website loads with no errors (ensure user is a member of the GRP-LABAPPVADMINS group)

Step 19: Select Servers on Left hand menu, Ensure LAB-APPV1 is successfully showing.

Install the latest Hotfix (at time of writing this is Hotfix 6)

Step 1: Obtain the Hotfix 6 for AppV 5.1 Server in the following MS KB3168628

Step 2: Run AppV5.1RTM_Server_KB3168628.exe as administrator

Step 3: Click Update

Step 4: Click i accept the license terms

Step 5: Click Next to confirm service interruption and hotfix to be installed.

Step 6: Installation progress will be shown.

Step 7: Click Close  and Reboot the Server