App-V: Installation of Management Server fails with Error 25109

You may get the following error during the installation of the App-V 4.5 Management Server, you get the following error:

Error 25109.The installation program could not create the configuration data store. Please see the installation log file for more information.

While this is a generic error, a new issues has been discovered where this can happen if one of the following conditions are true on the SQL Server:

1.) A pre-created empty database was selected (i.e. an empty APPVIRT database was created in advance.)

2.) The SQL Server is configured to use a Collation that is case-sensitive such as SQL_Latin1_General_Cp1_CS_AS_KI_WI (Dictionary order, case-sensitive)

For issue #1, Either do not pre-create the APPVIRT database or leverage the database creation scripts made available on the distribution media for App-V.

For issue #2, ensure the SQL Server you are using is leveraging a case-insensitive collation.

For more information on database pre-creation for App-V installations, please refer to the following document:

http://download.microsoft.com/download/1/6/1/161042F3-9CDE-45F7-BC20-4FBDA8888890/Creating_new_db_using_sql_scripting.docx

Information on SQL Collations can be found here: http://msdn.microsoft.com/en-us/library/ms144250.aspx