SQL SEVER2008R2 Database Services Various solutions that cannot be started

I. SQL Server service remote procedure call failure resolution

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 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 service is installed automatically, causing the original SQL2008 to not work correctly. Then the workaround is as follows:

① Method One:

Open the Control Panel, find the uninstaller, uninstall the 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, 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.

Two. The VIA protocol failed to open the service.

View the system log as follows:

Then use SQL Server's own log file viewer to view the SQL Server logs with the following error message:

You can see that the VIA protocol for SQL Server is problematic.

Go to SQL Server Configure manager, click the SQL Server network configuration (non-SQL Native Client configuration), point to sqlserver2008 (my SQL Server name) protocol, disable the VIA protocol.

Start the SQL Server service again, successfully.

Three. The user name has changed and cannot be logged in.

Open Control Panel-"Administrative Tools-" Service open SQL Sever Service Properties then log in box select Local user

This article is reproduced, online collection.

SQL SEVER2008R2 Database Services Various solutions that cannot be started