Wednesday, April 15, 2015

WMI provider error Invalid parameter [0X80041008] Error trying to change service account on SQL Server service


You may face the below error while changing back the SQL Server service accounts to virtual service accounts like NT Service\MSSQLServer then you may encounter the below error:

---------------------------
WMI Provider Error
---------------------------
Invalid parameter [0x80041008]
---------------------------
OK  
---------------------------
Resolution:

1. Verify whether NT Service\MSSQLServer, NT Service\SQLServerAgent accounts are find in the SQLServerSQLAgentUser$ComputerName, SQLServerMSSQLUser$ComputerName groups on computer management.

2. If there is no such virtual account add the account to those groups

3. Try use services.msc to change the service account to virtual service account (not use SQL configuration manager)




 

No comments: