I have been working on this for hours.
SCVMM service just fails to start. And here's the .net log it leaves behind:
Application: vmmservice.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.Data.SqlClient.SqlException at System.Data.SqlClient.SqlConnection.OnError(System.Data.SqlClient.SqlException, Boolean, System.Action1<System.Action>) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(System.Data.SqlClient.TdsParserStateObject, Boolean, Boolean) at System.Data.SqlClient.TdsParser.TryRun(System.Data.SqlClient.RunBehavior, System.Data.SqlClient.SqlCommand, System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.BulkCopySimpleResultSet, System.Data.SqlClient.TdsParserStateObject, Boolean ByRef) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(System.Data.SqlClient.SqlDataReader, System.Data.SqlClient.RunBehavior, System.String, Boolean, Boolean, Boolean) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, Boolean, Int32, System.Threading.Tasks.Task ByRef, Boolean, Boolean, System.Data.SqlClient.SqlDataReader, Boolean) at System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String, System.Threading.Tasks.TaskCompletionSource
1<System.Object>, Int32, System.Threading.Tasks.Task ByRef, Boolean ByRef, Boolean, Boolean) at System.Data.SqlClient.SqlCommand.RunExecuteReader(System.Data.CommandBehavior, System.Data.SqlClient.RunBehavior, Boolean, System.String) at System.Data.SqlClient.SqlCommand.ExecuteReader(System.Data.CommandBehavior, System.String) at System.Data.SqlClient.SqlCommand.ExecuteReader(System.Data.CommandBehavior) at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(System.TimeSpan) Exception Info: Microsoft.VirtualManager.DB.CarmineSqlException at Microsoft.VirtualManager.DB.SqlRetryCommand.InternalExecuteReader(System.TimeSpan) at Microsoft.VirtualManager.Engine.IDListDBHelper.ParseObjectIDListFromSqlCmd(Microsoft.VirtualManager.DB.SqlRetryCommand) at Microsoft.VirtualManager.DB.ImageLibrary.ServiceTemplateDBAccess.GetAllIds(Microsoft.VirtualManager.Engine.ConnectionProperties, Microsoft.VirtualManager.DB.IVmmDbContext) at Microsoft.VirtualManager.Engine.VirtualManagerService.LoadRefreshers(Microsoft.VirtualManager.DB.IVmmDbConnection) at Microsoft.VirtualManager.DB.SqlContext.Connect(System.Action`1<Microsoft.VirtualManager.DB.IVmmDbConnection>) at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(System.String, TimedStartupMethod) at System.Threading.Tasks.Task.Execute() Exception Info: System.AggregateException at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean) at System.Threading.Tasks.Task.Wait(Int32, System.Threading.CancellationToken) at Microsoft.VirtualManager.Engine.VirtualManagerService.WaitForStartupTasks() at Microsoft.VirtualManager.Engine.VirtualManagerService.TimeStartupMethod(System.String, TimedStartupMethod) at Microsoft.VirtualManager.Engine.VirtualManagerService.ExecuteRealEngineStartup() at Microsoft.VirtualManager.Engine.VirtualManagerService.TryStart(System.Object) at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.TimerQueueTimer.CallCallback() at System.Threading.TimerQueueTimer.Fire() at System.Threading.TimerQueue.FireNextTimers()
It does make the database at the start, I have tried reinstalling it, setting a new user for MSSQL, the query workaround nothing works.