SQL Server Configuration Manager – WMI Provider Error – “Invalid Parameter [0x80041008]”

Background

For a project that I am working on, I need to change the Service Account for SQL Server Agent.

 

Best Practice

Best practice is to to use SQL Server Configuration Manager to do so and so let us launch and use it.

 

SQL Server Configuration Manager

Steps

Here are the steps:

  1. Launch SQL Server Configuration Manager
  2. Access the SQL Server Services node
    • Choose the Service
    • In our case, SQL Server Agent (MSSQLSERVER)
  3. Current Service Account
    • The current Service Account is “Local System
  4. Choose the targeted User
    • Access the “Log On” as Tab
    • Choose the “This account” option button
    • Click the “Browse” button
      • The “Select User or Group” window appears
        • Click the “Advanced Button
        • Click the “Find Now” Button
        • Choose the Account
          • In our case “NETWORK SERVICE
  5. Apply Choice
    • Back in the “Log On” Tab
    • Now that have our target User, let us apply it
    • Review the account in the “Log On” textbox
    • Click the “Apply” Button
  6. Confirm Account Change
    • Upon clicking the “Apply” button, we are greeted with the “Confirm Account Change” dialog
    • The message reads “This will cause the service to be restarted.  Do you wish to continue
    • And, we reply YES
  7. Errored
    • Unfortunately, we received an error stating “Message :- Invalid Parameter [0x80041008]

 

 

Images

Built-in Account ( Original Setting )

sqlserveragent_thisaccount_localsystem

Select User or Group

selectuserorgroup_networkaccount_20170209_0241pm

 

SelectED User or Group

selectuserorgroup-networkservice-cropped-up

 

Apply Selected Account

selectuserorgroup_tab_logon_networkaccount_20170209_0246pm

 

Confirm Account Change

confirmaccountchange_20170209_0250pm

 

Error – WMI Provider Error – Invalid Parameter [0x80041008]

Image

wmiprovidererror-invalidparameter-0x80041008_20170209_0253pm

 

Textual

Header :- WMI Provider Error
Message :- Invalid Parameter [0x80041008]

Remediation

The error is that when we choose an Account, the system expects us to supply a password.

For so called system accounts, please do not choose “This Account” option button.

But instead, please choose the “Built-In Account” option button.

 

service_tab_logon_logonas_builtinaccount_20170209_0258pm

 

Currently, the available Built-in accounts are:

  1. Local System
  2. Local service
  3. Network Service

We chose Network Services.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s