最近数据库日志出现这个问题，数据库经常当掉

Question

win2003 +iis6
数据库是一台独立的服务器。局域网内部服务器。数据库最近老是当掉。查看日志出现这个情况


01/20/2010 16:27:17,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.100]
01/20/2010 16:27:17,登录,未知,错误: 18456，严重性: 14，状态: 8。
01/20/2010 16:27:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:27:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:27:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:27:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:27:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:27:03,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.2]
01/20/2010 16:27:03,登录,未知,错误: 18456，严重性: 14，状态: 8。
01/20/2010 16:27:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:27:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:27:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:26:28,登录,未知,Login succeeded for user 'web'. Connection: non-trusted. [客户端: 192.168.1.100]
01/20/2010 16:26:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:26:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:26:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:26:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:26:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:26:03,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.2]
01/20/2010 16:26:03,登录,未知,错误: 18456，严重性: 14，状态: 8。
01/20/2010 16:26:02,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:26:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:26:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:25:21,登录,未知,Login succeeded for user 'web'. Connection: non-trusted. [客户端: 192.168.1.100]
01/20/2010 16:25:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:25:06,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:25:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:25:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:25:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:25:03,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.2]
01/20/2010 16:25:03,登录,未知,错误: 18456，严重性: 14，状态: 8。
01/20/2010 16:25:02,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:25:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:25:00,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:24:56,登录,未知,Login succeeded for user 'web'. Connection: non-trusted. [客户端: 192.168.1.100]
01/20/2010 16:24:10,登录,未知,Login succeeded for user 'cms'. Connection: non-trusted. [客户端: 192.168.1.100]
01/20/2010 16:24:10,登录,未知,Login succeeded for user 'cms'. Connection: non-trusted. [客户端: 192.168.1.100]
01/20/2010 16:24:10,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.100]
01/20/2010 16:24:10,登录,未知,错误: 18456，严重性: 14，状态: 8。
01/20/2010 16:24:05,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:24:05,登录,未知,Login succeeded for user 'KDRS-B3LHACK9HX\sqlagent'. Connection: trusted. [客户端: <local machine>]
01/20/2010 16:24:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:24:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:24:03,登录,未知,Login succeeded for user 'sa'. Connection: non-trusted. [客户端: 192.168.1.2]
01/20/2010 16:24:02,登录,未知,Login failed for user 'sa'. [客户端: 192.168.1.2]
01/20/2010 16:24:02,登录,未知,错误: 18456，严重性: 14，状态: 8。

Answer 1

Log didn't tell why sql stopped, check windows event logs.

Answer 2

错误状态8是表示密码不匹配。
详见http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

---

I Love SQL Server!

Answer 3

Wrong sa password shouldn't take down sql.