question

ArashVenus-5903 avatar image
0 Votes"
ArashVenus-5903 asked XinGuo-MSFT edited

SCVMM Service fails to start

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.Action`1<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.

msc-virtual-machine-manager
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

XinGuo-MSFT avatar image
0 Votes"
XinGuo-MSFT answered XinGuo-MSFT edited

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.