??????????????? (Unix ????Windows)????????ó??? (Web ??????????????) ????????????????????????????????????????Windows Event Log?? SQL Server Error Log????????????? PS: SQL Server ?е??????? (Error Log) ?????? Oracle?е?alert ?????
?????. ??????????
????1. Windows????????SQL Server ???????
????Windows???????У???ó??????SQL Server??SQL Server Agent??????????????MSSQLSERVER??SQLSERVERAGENT??????????
????SQL Server????????????????Windows?????????????MSSQLSERVER??????????????￡?????????Windows??????????????ó???????????Щ????SQL Server?????????????о????????????????????磺
????Windows???????д????????
????Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 10.213.20.8]
????SQL Server????????д????????
????Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: 10.213.20.8]
????Error: 18456?? Severity: 14?? State: 8.
????2. ??????SQL Server??Error message??
???????????Error: 18456?? Severity: 14?? State: 8.???:
????(1) Error?????????????????????鵽?????????????
????select * From sys.messages where message_id = 18456
????(2) Severity????????????????????????????????25??????????????????????????????20~25??????????????????????У???SQL????TRY…CATCH??????????
????(3) State??????????????18456???????????????????????????????????????????
????1. Error information is not available. This state usually means you do not have permission to receive the error details. Contact your SQL Server administrator for more information.
????2.  User ID is not valid.
????5.  User ID is not valid.
????6.  An attempt was made to use a Windows login name with SQL Server Authentication.
????7.  Login is disabled?? and the password is incorrect.
????8.  The password is incorrect.
????9.  Password is not valid.
????11. Login is valid?? but server access failed.
????12. Login is valid login?? but server access failed.
????18. Password must be changed.
???????????δ?????State: 10?? State: 16???????SQL Server?????????????????????SQL Server????????
????3. SQL Server ?????????????Щ???
????SQL Server????????а???SQL Server????????С?????????????????л??????????????????????????????
????(1)  SQL Server/Windows??????????磺?汾????????IP/????????????CPU???????
????(2) SQL Server??????????????????????
????(3) SQL Server???????????????(????????????????)??
????(4) ??????????????????????KILL??????????DBCC?????????????
????(5) ???????/?????????
????(6) ?????????????棬?????DUMP????????????????
????(7) SQL Server?????????楨IO?????????楨?????????? (????????????Error 0)??
????(8) ??????????????????DBCC CHECKDB??????
????(9) ?????????
????????????????????Щ??????(trace flags)?????????????????????????磺?????????????????(login auditing)????????????е???????????????????????????????1204/1222 ???????
????????????????????SQL?????????????磺???????????????????????Windows???????(?????windows???????м???)??
????SQL Server Agent??????????????????????/????/?????????????????????