SQLTeam.com | Weblogs | Forums

NT SERVICE\MSSQLSERVER - WMI provider Error


#1

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


#2

use regedit to modify HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services<SQL Name>\ObjectName to NT AUTHORITY\LocalService, NT AUTHORITY\NetworkService or LocalSystem.
Hope it helps


#3

Thank you for the tip,

it is possible do it on domain controller ?

see : You cannot run SQL Server services on a domain controller under a local service account.
(https://msdn.microsoft.com/en-us/library/ms143506.aspx#DC_Support)


#4

Hello, just last two comments ....

  1. SQLSERVERAGENT service works without problem

  2. I'm surprised that I can not find powershell script for create permissions and rights SQL folder structure ...
    https://msdn.microsoft.com/en-us/library/ms143504.aspx
    I'm alone who have Domain and SQL ... or nobody create separate user for SQL services ...

  • I think the script would be very helpful