SQL Server service remote procedure call failed to resolve issue: SQL database login is not available today, and then want to start the SQL instance, but found the following problem (configuration environment: Win7 flagship version x64, SQLSERVER2008R2, installing VS2012 at the same time): previously had this problem, because the instance was installed on the D drive, and then the D drive was formatted. And then, these are gone. This morning turned on the computer, unexpectedly this problem, but server2008r2 all installed in the C drive. Workaround: Finally find a workaround and discover that the cause of the failure is: When you install Visual Studio 2012, the Microsoft SQL Server Express LocalDB is installed automatically Service, causing the original SQL2008 not to work properly. Then the workaround is as follows: ① method One: Open the Control Panel, locate the program-I uninstall program, uninstall Microsoft SQL Server Express LocalDB, and then open SQL Server Configuration Manager and show that everything is OK. but my VS2012 has been installed for more than half a month, how come this problem today? ② method Two: Upgrade sqlserver2008r2 to SP1 or SP2. But now emergency, my example is still in, just do not start, try the following methods: Right-click "Computer" → "Management" → "service", find SQL Server (MSSQLSERVER), right click, select "Start". Log in to the database again, no problem. But after restarting the system, the problem will remain the same. Summary: Want to fix this problem permanently and use the method above. 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.
