SQL – Server Error: “The remote procedure call failed. [0x800706be]”
This error only occurs, if your sql Server Agent services disabled.
If your Sql server Agent service stopped then you can not connect / open sql server.
We can start sql server Agent two ways:
First : Start sql server Agent from SQL Server Configuration Manager.
Start Menu –> All Programs –> SQL – Server 2008 — > Configuration Tools, and then open the SQL Server Configuration Manager.
Now, In SQL Server Configuration Manager, Click on Services, and then click SQL Agent.
Then just Right-click any instance, and then click Start.
Second : Start sql server Agent from Run command:
Open the Run and Type services.msc and click..
You will have many services in opened windows..
Find out SQL Server Services and Right Click on it and enable Start Automatically.
Here, below we have given some screen shot yo understand process of star sql server agent easily.
Click on startup and select Run option for open RUN prompt.
In Run dialog box write services.msc command and click ok button.
Below screen display all the services of your system. Find out the SQL Server Browser and right click on SQL Server Browser and select Start option to start the services as shows like below sql figure.