SQL Server Error Summary

Open a single chapter, log the problems of SQL Server encountered and the solution, to facilitate their own later review.

The article will continue to improve

1) SQL Server service suddenly failed to start

Problem Description: There has been no problem, suddenly one day can not start

Workaround: View the Control Panel-> Admin Tool-> Event Viewer and discover that it failed to start because of a login failure.

To find out why, it's easy to find the services for SQL Server from the service, right-click Properties, and then open the Login tab, select the Local system, and OK.

This problem is mostly due to changes to the operating system's login password. So to update SQL Server's account login password. The best way to do that, of course, is to 觪 the decision.

This will be updated automatically later.

2) 17051 Error

Code 17051: After a long time, we know that this is the evaluation period. With a valid serial number update on the line.

3) Error code 126

Disable the VIA protocol, then start the service, OK

4) The solution of the error 233

Open ' programs '-' All Programs '-' Microsoft SQL Server '-' configuration Tools '-' SQL Server Configuration Manager ', and in the form that pops up, find ' SQL Server network configuration ' and ' Named ' under ' MSSQLServer ' protocol ' Pipes and TCP/IP to start, and then restart Microsoft SQL Server

5 Message 15466, Level 16, State 2, Process sp_addlinkedsrvlogin, 91st line decryption process error.

Message 15185, Level 16, State 1, Process sp_addlinkedsrvlogin, line 98th

There is no remote user ' XXXXXXX ' mapped from remote server ' XXXXXX ' to local user ' (null) '.

Workaround: Execute on the local server: ALTER SERVICE MASTER KEY FORCE regenerate.

The function of this statement is to regenerate the master key for the local server.

6:sqlserver Resume Hangs

ALTER DATABASE dbname

Set Online