Preface
Just opened SQL Server 2008 and want to create a new database. Found a problem, the problem has not been encountered before, so this time to take out some solutions.
content
The reason for this error may be because we are loading VS2012 or other versions, this vs will automatically install the "Microsoft SQL Server expresslocaldb" service, resulting in SQL server2008, The SQL Server service shows that the remote procedure call failed. Knowing the cause of the other is pretty straightforward.
First: Adopt A gentle way
obediently Upgrade your database to a higher version.
Second: Just take a look
If you use this database only once, go to the computer → manage → service, find the service to open SQL Server (MSSQL server) to start is OK.
Third: Not on
Of course, life, you have to learn not to, because the teacher said: not will be the driving force of discovery. So, in order to use the normal use every time, can only be wronged "Microsoft SQL Server (EXPRESSLOCALDB)" This service, fish and bear cake can not be combined. So go to the control panel decisively find this automatic installation of the service, to uninstall it, there is no big impact on vs. After uninstalling, then turn on the required services under the SQL Server service.
Then again, vs why to automatically install "Microsoft SQL Server (EXPRESSLOCALDB)", the baby really do not know, but look at the surface meaning, should be a local database or something??? Baidu told me: VS2012 provides a local database engine "Microsoft SQL Server expresslocaldb", through VS2012 can easily manage and use the local database.
Summary
1, will not be the motive force of discovery.
Thank you for your valuable time ...
SQL Server Remote debugging failed