SCVMM Service fails to start

Arash Venus 21 Reputation points
2021-06-14T15:50:56.85+00:00

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.TaskCompletionSource1<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.

System Center Virtual Machine Manager
{count} votes

Accepted answer
  1. XinGuo-MSFT 15,781 Reputation points
    2021-06-15T06:59:48.36+00:00

    Hi,

    Please try to enable VMM Tracing to collect debug logging and find the detail SQL exceptions.

    How to enable debug logging in Virtual Machine Manager

    https://support.microsoft.com/en-us/topic/how-to-enable-debug-logging-in-virtual-machine-manager-e469331f-6a8b-9fa6-69dd-170c6c4a5303

    There is a similar thread you can reference:

    VMM SERVICE CRASHES ON START WITH EXCEPTION CODE

    Note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

    0 comments No comments

0 additional answers

Sort by: Most helpful