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

View products that this article applies to.

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:

Planning for High Availability with App-V 5.0

↑ Back to the top

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

↑ Back to the top

Workaround

To work around this issue, follow these steps:

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)
```
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
```
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.