locked
NT SERVICE\MSSQLSERVER - WMI provider Error RRS feed

  • Question

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

    Monday, February 6, 2017 2:24 PM

All replies

  • Did you tried answer mentioned in below thread

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/fc49d972-ff3b-422a-b30f-fca81962cd0b/sql-server-config-mgr-error-wmi-provider-error-cannot-find-object-or-property?forum=sqlgetstarted


    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Monday, February 6, 2017 2:57 PM
  • 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)
    Thursday, February 9, 2017 11:41 AM
  • 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)
    As fact you should not install SQL Server on domain controller this is NOT supported, and yep correct you should not run SQL Server account with local system on Domain Controller

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Thursday, February 9, 2017 11:44 AM
  • 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

    Friday, February 10, 2017 10:06 AM
  • Hi Kyssling,

    Firstly, it is not supported to install SQL Server 2016 on a domain controller, from my point of view, it is not abnormal that you can’t change SQL Server Service account to NT SERVICE\MSSQLSERVER.

    Secondly, to grant users permissions on SQL Server folders using PowerShell scripts, please follow  the instructions in the following similar blogs.

    How To Manage File System ACLs With PowerShell
    Weekend Scripter: Use PowerShell to Get, Add, and Remove NTFS Permissions


    Thanks,
    Lydia Zhang


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.



    Thursday, March 2, 2017 7:12 AM