SQL Server Error Summary

Open a unit to record the SQL Server problems and solutions for future review.

This article will be continuously improved

1) the SQL Server service suddenly fails to start.

Problem description: there was no problem before, and suddenly it could not be started one day.

Solution: Choose Control Panel> Administrative Tools> Event Viewer and find that the startup fails because of Logon failure.

Find the cause, and you can find the SQL Server service from the service. Right-click the attribute and open the "Log on" tab. Select the local system and click OK.

Most of the problems are caused by changing the logon password of the operating system. Therefore, you must update the logon password of the sqlserver account. Of course, the best way is to make the above decision.

This will automatically update later.

2) Error 17051

Code 17051: I checked it for half a day before I realized that this was an evaluation period. Update it with a valid serial number.

3) error code 126

Disable the via protocol and start the service again.

4) Error 233 Solution

Open 'program '-'All projects'-'Microsoft SQL Server'-'configuration tool'-' SQL Server Configuration Manager'. In the displayed form, find 'SQL Server network configuration', start "Named Pipes" and "TCP/IP" under 'mssqlserver Protocol', and then restart Microsoft SQL Server

5) an error occurs during message 15466, level 16, status 2, sp_add1_srvlogin, and 91st line decryption.

Message 15185, level 16, status 1, process sp_add1_srvlogin, 98th rows

No remote user 'xxxxxxxxx' mapped from remote server 'xxxxxx' to local user '(null '.

Solution: Run alter service master key force regenerate on the local server.

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

6: SQL Server resume Suspension

Alter database dbname

Set online