SQL Server Agent gives- Remote procedure call failed (0x800706be)

sql-server-2008-r2
Subek Shakya picture Subek Shakya · Jul 21, 2012 · Viewed 57.2k times · Source

Does Anyone knows the solution to this problem m not being able to run the SQL Server Services.

enter image description here

Answer

Fernando JS picture Fernando JS · Sep 25, 2013

Solution: Install SQL Server 2008 R2 SP2, restart, open SQL Server Configuration Manager and ALL is good.

Source: Frozen bytes

Related questions

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The statement has been terminated

I have many users on my web site (20000-60000 per day), which is a download site for mobile files. I have remote access to my server (windows server 2008-R2). I've received "Server is unavailable" errors before, but am now seeing …

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More