NT SERVICE\MSSQLSERVER - WMI provider Error

1

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

sql-server
asked on Stack Overflow Feb 6, 2017 by Kyssling

1 Answer

0

I found information than NT SERVICE\ impossible set for SQL accounts under Domain Controller ... https://blogs.technet.microsoft.com/mdegre/2011/06/25/can-i-install-sql-server-on-a-domain-controller/

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

answered on Stack Overflow Feb 10, 2017 by Kyssling

User contributions licensed under CC BY-SA 3.0