Did some experimentation, and modified a couple of stored procedures in the AS_Testcenter.SQL script. Changed ALTER to CREATE for the following stored procedures..... CREATE PROCEDURE [dbo].[sp_asrpt_GetValidatedAndConflictedPackages] CREATE PROCEDURE [dbo].[sp_asrpt_VirtualizationReadinessCheck_All] This 'seemed' to work, as the AS_Testcenter.SQL script executed without any errors, however this message does appear: The module 'sp_asrpt_VirtualizationReadinessCheck_All' depends on the missing object 'sp_asrpt_VirtualizationReadinessCheckHelper'. The module will still be created; however, it cannot run successfully until the object exists. The module 'sp_asrpt_VirtualizationReadinessCheck_All' depends on the missing object 'sp_asrpt_VirtualizationReadinessCheckHelper'. The module will still be created; however, it cannot run successfully until the object exists. The module 'sp_asrpt_VirtualizationReadinessCheck_All' depends on the missing object 'sp_asrpt_VirtualizationReadinessCheckHelper'. The module will still be created; however, it cannot run successfully until the object exists. The module 'sp_asrpt_VirtualizationReadinessCheck_All' depends on the missing object 'sp_asrpt_VirtualizationReadinessCheckHelper'. The module will still be created; however, it cannot run successfully until the object exists. Would anyone @ Flexera be able to verify/validate this? ... View more

Thanks for the post Evan regarding the order of SQL script execution. I am trying to install the App Catalog DB manually as well in SQL 2008 R2, and am getting the following errors: For the following SQL scripts..... AS_System_Schema.SQL Msg 102, Level 15, State 1, Line 18 Incorrect syntax near 'DUMP'. Msg 319, Level 15, State 1, Line 18 Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon. AS_TestCenter.SQL Msg 208, Level 16, State 6, Procedure sp_asrpt_GetValidatedAndConflictedPackages, Line 97 Invalid object name 'dbo.sp_asrpt_GetValidatedAndConflictedPackages'. Msg 208, Level 16, State 6, Procedure sp_asrpt_VirtualizationReadinessCheck_All, Line 82 Invalid object name 'dbo.sp_asrpt_VirtualizationReadinessCheck_All'. Would you happen to have a fix for these? I've followed the exact order specified in your previous post. This is for Adminstudio 11.5 SP1. Thanks! ... View more