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

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

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

  • This was removed by the editor as SPAM

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply