my personal blog about systemcenter

Virtual Machine Manager 2016 TP2 Require SQL Enterprise Edition

So at least for now during the preview manually installed VMM require SQL Enterprise Edition and not Standard

Will be interresting to see if this is still a requirement at GA , and if the SQL entitlement will follow


The Virtual Machine Manager database was not created.
The Virtual Machine Manager database was not created. Delete NO_PARAM.mdf and NO_PARAM_log.ldf if they exist at NO_PARAM or use a unique name for the database. Also, verify that disk quota management is not enabled for the drive where the database is being created. Then run Setup again.
09:15:47:Failed sql script: Threw Exception.Type: Microsoft.VirtualManager.DB.CarmineSqlException, Exception.Message: Unable to connect to the VMM database because of a general database failure.
Ensure that the SQL Server is running and configured correctly, then try the operation again.
09:15:47:StackTrace: at Microsoft.VirtualManager.DB.SqlRetryCommand.ExecuteNonQuery()
at Microsoft.VirtualManager.DB.SqlContext.ExecuteNonQueryCommand(String command, Action`1 parameterAdder)
at Microsoft.VirtualManager.Setup.DBConfigurator.ExecuteScript(String fileName, IVmmDbTransaction tx)
09:15:47:InnerException.Type: System.Data.SqlClient.SqlException, InnerException.Message: Online index operations can only be performed in Enterprise edition of SQL Server.
09:15:47:InnerException.StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.VirtualManager.DB.SqlRetryCommand.ExecuteNonQuery()
09:15:47:Out of Impersonation