When I installed Visual Studio 2012, the current installation of SQL Server 2008 got bad.
When I tried to access my sever created on the local machine, got the error -
Remote procedure call failed (0x800706be) in SQL Server 2012
The solution was simple. To install SP3 for SQL Server 2008. Though easy it took lot of time to find out the root cause.