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


You may be unable to install or upgrade the Microsoft App-V 5.0 Service Pack 3 (App-V 5.0 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

This issue occurs because the scripts listed below reference the SchemaChanges table and this table is no longer used in App-V 5.0 SP3:

- InsertVersionInfo.sql
- Permissions.sql

For all the details regarding this issue as well as a work around, please see the following:

KB3031340 - SQL scripts to install or upgrade the App-V 5.0 SP3 Management Server database fail (http://support.microsoft.com/kb/3031340)

J.C. Hornbeck | Solution Asset PM | Microsoft GBS Management and Security Division

Get the latest System Center news on Facebook and Twitter:

clip_image001 clip_image002

Main System Center blog: http://blogs.technet.com/b/systemcenter/

Configuration Manager Support Team blog: http://blogs.technet.com/configurationmgr/
Data Protection Manager Team blog: http://blogs.technet.com/dpm/
Orchestrator Team blog: http://blogs.technet.com/b/orchestrator/
Operations Manager Team blog: http://blogs.technet.com/momteam/
Service Manager Team blog: http://blogs.technet.com/b/servicemanager
Virtual Machine Manager Team blog: http://blogs.technet.com/scvmm

Microsoft Intune: http://blogs.technet.com/b/microsoftintune/
WSUS Support Team blog: http://blogs.technet.com/sus/
RMS blog: http://blogs.technet.com/b/rms/
App-V Team blog: http://blogs.technet.com/appv/
MED-V Team blog: http://blogs.technet.com/medv/
Server App-V Team blog: http://blogs.technet.com/b/serverappv

Forefront Endpoint Protection blog: http://blogs.technet.com/b/clientsecurity/
Forefront Identity Manager blog: http://blogs.msdn.com/b/ms-identity-support/
Forefront TMG blog: http://blogs.technet.com/b/isablog/
Forefront UAG blog: http://blogs.technet.com/b/edgeaccessblog/
Application Proxy blog: http://blogs.technet.com/b/applicationproxyblog/
The Surface Team blog: http://blogs.technet.com/b/surface/

Comments (0)

Skip to main content