Tag: WMI Provider Error

SQL Server – WMI Provider Error

Was changing the SQL Server Service Account on an SCCM SQL Server 2012 to a dedicated Service Account instead of Local System (recommended best practices).

Went to the SQL Server Error Log text file to get some more context on the error as SQL Server hadn’t started because of the error.

Here what I found:

Solution:

Full Control on the following objects to the service account:

C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\
C:\ProgramData\Microsoft\Crypto\RSA\MachineKeys
HKLM\System\CurrentControlSet\Services\WinSock2\Parameters