SQL SEVER2008R2 Database Services solutions for all kinds of problems that fail to start (detailed) _mssql2008

A. SQL Server service remote procedure call failure resolution

This problem occurred before because the example was installed in D, and the D disk was later formatted. Then, these are gone. This morning turned on the computer, unexpectedly again appeared this problem, but server2008r2 all installed in C plate.

Workaround:

Finally find a workaround and discover the cause of the failure: the Microsoft SQL Server Express LocalDB Service was automatically installed when visual Studio 2012 was installed, causing the original SQL2008 to not work properly. Then the solution is as follows:

① Method One:

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

But my VS2012 has been installed for more than half a month, how come this problem today?

② Method II:

Upgrade SQLSERVER2008R2 to SP1 or SP2.

But now urgently, my example is still, just did not start it, try the following methods:

Right-click computer → admin → services, locate SQL Server (MSSQLSERVER), right-click, and select Start.

Login to the database again, no problem. But after restarting the system, the problem will remain.

Summarize:

The above method is also needed to permanently resolve the problem. To prevent it, it's best to go in and back up your database, or create a System restore point, and then try again. In general, both of the above methods are due to Microsoft compatibility issues, or uninstall the new back to the old version, or upgrade to a new version. Therefore, I have passed the second method, the perfect realization of normal.

Two. The VIA protocol fails to open the service.

View the system log as follows:

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

You can see the problem with the VIA protocol for SQL Server.

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

Then start the SQL Server service successfully.

Three. User name changed, unable to log in.

Open Control Panel-"Admin tools-" Service open SQL Sever service properties and login checkbox Select Local User

The above is a small set to introduce the SQL SEVER2008R2 database services to all kinds of problems can not start the solution (detailed), I hope to help you, if you have any questions please give me a message, small series will promptly reply to everyone. Here also thank you very much for the cloud Habitat Community website support!