Many of the developers of the comrades, believe that in the first use of SQL server2008+c#2012 (more than 2012 version) will appear in the following picture of the problem, because the installation of Visual Studio 2013 or 2012, will automatically install the "Microsoft SQL Server (+) Express LocalDB "service, which caused the original SQL2008 to not work properly.
Below, I will use two methods to help you solve this problem.
Tools/Materials
-
Windows system
-
VS 2013
-
SQL Server 2008
Method/Step
-
The first approach is
Open the Control Panel, locate the uninstaller, uninstall Microsoft SQL Server Express LocalDB, and then open SQL Server Configuration Manager and it will show normal use.
-
The second option is to upgrade the database
Use a later version of the database, or upgrade SqlServer2008 to SP1 or SP2.
-
The third method is to manually start the database service entry
Here's how:
Right-click computer → administration → services, locate SQL Server (MSSQLSERVER), right-click, and select Start. There is no problem logging into the database at this time, but after restarting the system, the problem will persist.
From: http://jingyan.baidu.com/article/9f63fb91d436b4c8410f0e5c.html
SQL Server service Remote procedure call failed to resolve