SQL Server service Remote Procedure call failed

Questions:

Today SQL Database login is not up, and then want to start the SQL instance, but found the following problem (configuration environment:win7 flagship x64,sqlserver2008r2, Install VS2012 at the same time ):

This problem has occurred before, because the instance was installed in D , and then the D Drive was formatted. And then, these are gone. This morning turned on the computer, unexpectedly this problem, but the Server2008R2 all installed in the C Drive.

Workaround:

Finally, find a workaround and find the cause of the failure: automatically install the Microsoft SQL Server Express LocalDB Service when you install visual Studio Causes the original SQL2008 not to work properly. Then the workaround is as follows:

① Method One:

Open the Control Panel, locate the program---Uninstall program, uninstall Microsoft SQL Server Express LocalDB, and then open SQL Server Configuration Manager, showing that everything is fine It's OK.

But my VS has been installed for more than half a month, how come this problem today?

② Method Two:

Upgrade SQL Server2008R2 to SP1 or SP2. Official website: http://www.microsoft.com/zh-cn/download/details.aspx?id=30437

But now emergency, my example is still in, just do not start, just try the following methods:

Right-click computer → administration → services, locate SQL Server(MSSQLSERVER), right-click, and select Start.

Log in to the database again, no problem. But after restarting the system, the problem will remain the same.

Summarize:

The above method is needed to resolve the problem permanently. As a precaution, it's best to go in and back up your database, or create a System restore point and try again. In general, the two methods above are due to Microsoft compatibility issues, either uninstall the new back to the old version, or upgrade to a new version. So, I have passed the second method, perfect to achieve normal.

SQL Server service Remote Procedure call failed