Starting SQL Server Agent - WMI Provider Error - The remote procedure call failed.

• nickm_GR

  SSCommitted

  Points: 1961

  More actions

  August 12, 2014 at 1:13 pm

  #397191

  So I was adding a new named instance to one of my servers. These instances are just data repositories that get rebuilt every night, so they're not backed up or anything. I set the SQL agent to disabled while setting it up.

  I was using the copy database wizard and realized the package wouldn't work because the agent wasn't running (error told me as much). When I try to go into SQL Server Configuration Manager and change the start mode from "disabled" to "manual", when I hit apply I get this error:

  WMI Provider Error

  The remote procedure call failed. [0x800706be].

  This is a Windows Server 2008 R2 enterprise server running SQL Server 2008 R2 SP2.

  Anyone seen that before?

• WorkasDBA

  SSCommitted

  Points: 1684

  More actions

  August 12, 2014 at 2:25 pm

  #1737354

  SQL Server Agent is a dependent service on SQL Server Service. Try getting into 'Service Manager' and change it to automatic.

• nickm_GR

  SSCommitted

  Points: 1961

  More actions

  August 13, 2014 at 8:12 am

  #1737603

  I ended up re-installing the instance. Works fine now. Thanks though gents!