SQL Sever Connection not on--sql Sever service remote Procedure call failed

Today, I started the three-storey learning, watching video, knocking code, feel for a long time did not hit the code, the hands are a bit raw ... The code finally finished, started to build the database, and then the problem arose. My database is in winter vacation home before the reload system installed, then was connected, and then no longer use ... Open again, the problem arises.

Originally thought this problem is not very difficult, used to do the computer room when the database is not connected to check the configuration tool is ok ... When I went to see it, there was nothing, and then it appeared.

I do not direct Baidu this issue, but Baidu's database is not connected to the server:

Http://zhidao.baidu.com/link?url=sVK4aycj7hPhBLXvt5MbG4a70PtWaLNSShfAqfotZY6yo1yXbQd8_GASComGcBcBEMTVrTggCWG8VXgVKF5iZK

According to Baidu said, I went to do, but I do not know the system service where, I went to ask Juan sister, she said should be in the local strategy, but we have forgotten the local policy command, so also Baidu

Http://jingyan.baidu.com/article/49711c6148c372fa441b7c13.html

But the SQL system service is not in the local strategy, followed by Baidu, we found in the management tool-service-(service) Local

It is then automatically changed to Manual.

then follow Baidu to check whether the SQL Server network configuration is enabled.

Now it's time to resolve the problem with the remote procedure call failing:

The problem is that when you install visual Studio2012, the Microsoft SQL Server Express LocalDB service is installed automatically, which prevents the original SQL2008 from working correctly. Then the workaround is as follows:

One

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

Two

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

All the problems are solved, and then look at the configuration tool to restore to the familiar look ...

Go back to the database and connect!

Summary : Encountered do not understand, we have to step-by-step to check, once again realize that the method of rice teacher more than the problem! There is the habit of the backup, do not simply believe that any one, multi-backup to prevent file loss and corruption. There is not always simple self-thought, think how to solve the problem, in different situations, the cause of the problem arises is not the same, we should be good at solving problems.

SQL Sever Connection not on--sql Sever service remote Procedure call failed