Microsoft Application Virtualization Management Service fails to Start when installed on the same machine as SQL Server 2005

Source: Microsoft Support

RAPID PUBLISHING ARTICLES PROVIDE INFORMATION DIRECTLY FROM WITHIN THE MICROSOFT SUPPORT ORGANIZATION. THE INFORMATION CONTAINED HEREIN IS CREATED IN RESPONSE TO EMERGING OR UNIQUE TOPICS, OR IS INTENDED SUPPLEMENT OTHER KNOWLEDGE BASE INFORMATION.

When the Application Virtualization Management Service (HWS) is installed on the same server as the SQL Server hosting the data store, the services do not wait for the SQL Server to start prior to trying to start the Management Server. As a result, the SQL server may not be ready and as a result, the Application Virtualization Management Server is unable to start.

This is an issue with service load order. If the SQL Server has not finished starting, the App-V Management Server will fail to start.

To workaround this issue:

 

To configure a service dependency, open the Registry Editor and open the key HKEY_LOCAL_MACHINE\ SYSTEM\CurrentControlSet\Services\AppVirtServer and add a REG_MULTI_SZ value named DependOnService to the key, then edit the value of DependOnService to add the service name of the service you want started before the AppVirtServer service starts which in this case will be the SQL service (MSSQLSERVER),

 

Note  If the AppVirt datastore ever gets moved to a different server this dependency has to be removed or the App-V Management Server service will fail to start.

MICROSOFT AND/OR ITS SUPPLIERS MAKE NO REPRESENTATIONS OR WARRANTIES ABOUT THE SUITABILITY, RELIABILITY OR ACCURACY OF THE INFORMATION CONTAINED IN THE DOCUMENTS AND RELATED GRAPHICS PUBLISHED ON THIS WEBSITE (THE “MATERIALS”) FOR ANY PURPOSE. THE MATERIALS MAY INCLUDE TECHNICAL INACCURACIES OR TYPOGRAPHICAL ERRORS AND MAY BE REVISED AT ANY TIME WITHOUT NOTICE.

TO THE MAXIMUM EXTENT PERMITTED BY APPLICABLE LAW, MICROSOFT AND/OR ITS SUPPLIERS DISCLAIM AND EXCLUDE ALL REPRESENTATIONS, WARRANTIES, AND CONDITIONS WHETHER EXPRESS, IMPLIED OR STATUTORY, INCLUDING BUT NOT LIMITED TO REPRESENTATIONS, WARRANTIES, OR CONDITIONS OF TITLE, NON INFRINGEMENT, SATISFACTORY CONDITION OR QUALITY, MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, WITH RESPECT TO THE MATERIALS.