SQL scripts to install or upgrade the App-V 5.0 SP3 Management Server database fail

Applies to: Microsoft Application Virtualization Hosting 5.0 for Windows Desktops

Symptoms


You may be unable to install or upgrade the Microsoft App-V 5.0 Service Pack 3 (SP3) Management Server database if you use SQL scripts that were obtained by using the method that is documented in the "Support for Microsoft SQL Server clustering" section of the following Microsoft TechNet article: 

Cause


This issue occurs because you are using the following scripts. These scripts reference the SchemaChanges table, and this table is no longer used in App-V 5.0 SP3. 
  • InsertVersionInfo.sql
  • Permissions.sql

Workaround


To work around this issue, follow these steps:
  1. Update the InsertVersionInfo.sql script to reference the new SchemaVersion table. To do this, follow these steps:
    1. In InsertVersionInfo.sql, locate the following line:
      INSERT INTO dbo.SchemaChanges VALUES(@dbversion, @minserviceversion)
    2. Change this to the following line:
      INSERT INTO dbo.SchemaVersion VALUES(2)
  2. Update the Permissions.sql script to reference the new SchemaVersion table. To do this, follow these steps:
    1. In Permissions.sql, locate the following line:
      GRANT SELECT ON dbo.SchemaChanges TO PUBLIC
    2. Change this to the following line:
      GRANT SELECT ON dbo.SchemaVersion TO PUBLIC
  3. Follow the instructions that are listed in the ReadMe.txt file to install or upgrade to the App-V 5.0 SP3 Management Server database. You can find this file in the Management folder.