none
最近数据库日志出现这个问题,数据库经常当掉 RRS feed

  • 问题

  • 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。

    2010年1月20日 8:53

答案

全部回复