Hello, I tried on MS SQL SERVER 2016 Standard change with SQL Configuratin Manager service SQL Agent from LocalSystem to
NT SERVICE\SQLSERVERAGENT (without problems).
When I change SQL Server service from LocalSystem to NT SERVICE\MSSQLSERVER i get message "WMI Provider Error" - not object or property found 0x80092004 Systemlog: SQL Server service (MSSQLSERVER) ended with the following specific error Service: object or property is not found. ID: 7024
The server normally works with SQL services under Local System and works without problems. For Database Mail I need to configure the service to NT SERVICE.
SQL run under Windows Server 2012 R2.
I tried unsuccessfully to:
Reboot the server, change login name direct with Services.msc, Powershell get-service | foreach {Write-Host NT Service \ ( _. Name)} NT SERVICE\MSSQLSERVER exists, WMI Diagnosis Utility (in my opinion, nothing major found).
Thank you for your help ...