SQL Server Error Summary

1) SQL Server service suddenly fails to start

Problem Description: There was no problem, suddenly one day could not start

Workaround: View the Event Viewer, Administrative Tools, control Panel, and discover that the login failed to start.

Find the reason, it is simple, from the service to find the SQL Server services, right-click Properties, and then open the "Login" tab, select the Local system, OK.

This problem is mostly caused by changing the operating system's login password. So update the account login password for SQL Server. Of course, the best way is the pursue.

This will automatically be updated later.

2) 17051 Error

Code is 17051: Check for a long time, just know this is the evaluation period too. It's OK to update it with a valid serial number.

3) Error code 126

Disable the VIA protocol and start the service again, OK.

4) Resolution of error 233

Open ' programs '-' All Programs '-' Microsoft SQL Server '-' configuration Tools '-' SQL Server Configuration Manager ', in the popup form, locate ' SQL Server network configuration ', put ' MSSQLSERVER protocol ' under ' Named ' Pipes "and" TCP/IP "start, and then restart Microsoft SQL Server

5) message  15466 16 2 91

15185 16 1 98

   not   from remote server; " xxxxxx " " ( NULL) "   Remote users   " xxxxxxx

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

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

SQL Server Error Summary