数据库异常停止，不知道是什么原因（急等）

[randomfeel]

最开始怀疑是死锁，导致无法访问数据库
死锁暂时未能完全解决，就先加了日志功能。有时确实能记录到一些死锁的日志，那么就把一些被牺牲的进程停止掉

但是后来发觉似乎不是死锁的问题。在好几次没有死锁日志的情况下，数据库服务异常，能在里面执行查询语句，但是程序服务器访问失败了

我看了数据库的errorlog，里面有如下一段，请大家帮忙分析

012-06-11 20:44:31.32 登录 Login failed for user 'sa'. [客户端: xxx.xxx.xx.xx]
2012-06-11 20:44:31.37 登录 错误: 18456，严重性: 14，状态: 8。
2012-06-11 20:44:31.37 登录 Login failed for user 'sa'. [客户端: xxx.xxx.xx.xx]
2012-06-11 20:44:31.46 登录 错误: 18456，严重性: 14，状态: 8。
2012-06-11 20:44:31.46 登录 Login failed for user 'sa'. [客户端: xxx.xxx.xx.xx]
2012-06-11 20:44:31.54 spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager. This is an informational message only. No user action is required.


其中 xxx.xxx.xx.xx是具体IP，这样的记录很多。而且分别是不同IP来的。。

[發糞塗牆]

http://blog.csdn.net/dba_huangzj/article/details/7650348
我的这篇博文有说，你搜一下吧
具体解决方法你详细看看。我也不好叫你侧这个测那个，
用户认证失败，SQLServer认为连接使用了一个非法用户而拒绝：
Login failed for user “Null”
“消息 18456，级别 14，状态 1，服务器 <computer_name>，第1行”
“用户‘<user_name>’ 登录失败

[randomfeel]

各种IP尝试登录SA失败。是不是意外着有人尝试破解SA的密码啊
我就一个程序在链接数据库而已，全是些我不认识的IP

[haitao]

是局域网ip还是互联网ip？
很可能是中毒的机器在反复登录

【spid7s SQL Server is terminating in response to a 'stop' request from Service Control Manager】
说明是人为关闭啊

[randomfeel]

有时是人为关闭的，然后再重新启动。不然的或程序一直连接不上

我的程序是通过局域网IP访问数据库的

[lichever528]

写详细一点

[昵称被占用了]

检查有无最大内存设置，如果不设置可能会造成内存占用过多而性能下降，不能登陆。

[randomfeel]

2012-06-12 22:49:03.56 服务器 SQL Server is starting at high priority base (=13). This is an informational message only. No user action is required.
2012-06-12 22:49:03.56 服务器 Detected 16 CPUs. This is an informational message; no user action is required.
2012-06-12 22:49:03.70 服务器 Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2012-06-12 22:49:03.90 服务器 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2012-06-12 22:49:03.90 服务器 Lock partitioning is enabled. This is an informational message only. No user action is required.
2012-06-12 22:49:03.97 服务器 Multinode configuration: node 0: CPU mask: 0x0000f0f0 Active CPU mask: 0x0000f0f0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2012-06-12 22:49:03.97 服务器 Multinode configuration: node 1: CPU mask: 0x00000f0f Active CPU mask: 0x00000f0f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.
2012-06-12 22:49:03.97 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2012-06-12 22:49:04.98 服务器 Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2012-06-12 22:49:05.01 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2012-06-12 22:49:05.01 spid7s Starting up database 'master'.
2012-06-12 22:49:05.12 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2012-06-12 22:49:05.18 spid7s SQL Trace ID 1 was started by login "sa".
2012-06-12 22:49:05.18 spid7s Starting up database 'mssqlsystemresource'.
2012-06-12 22:49:05.31 spid7s Server name is 'WIN2003-xxxxxx'. This is an informational message only. No user action is required.
2012-06-12 22:49:05.31 spid11s Starting up database 'model'.
2012-06-12 22:49:05.42 spid11s Clearing tempdb database.
2012-06-12 22:49:05.57 服务器 A self-generated certificate was successfully loaded for encryption.
2012-06-12 22:49:05.57 服务器 Server is listening on [ 'any' <ipv4> 1433].
2012-06-12 22:49:05.59 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2012-06-12 22:49:05.59 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2012-06-12 22:49:05.59 服务器 Server is listening on [ 127.0.0.1 <ipv4> 1434].
2012-06-12 22:49:05.59 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2012-06-12 22:49:05.59 服务器 The SQL Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b. Failure to register an SPN may cause integrated authentication to fall back to NTLM instead of Kerberos. This is an informational message. Further action is only required if Kerberos authentication is required by authentication policies.
2012-06-12 22:49:05.59 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2012-06-12 22:49:05.61 spid14s Starting up database 'msdb'.
2012-06-12 22:49:05.61 spid15s Starting up database 'ReportServer'.
2012-06-12 22:49:05.61 spid16s Starting up database 'ReportServerTempDB'.
2012-06-12 22:49:06.89 spid11s Starting up database 'tempdb'.
2012-06-12 22:49:07.43 spid14s The Service Broker protocol transport is disabled or not configured.
2012-06-12 22:49:07.43 spid14s The Database Mirroring protocol transport is disabled or not configured.
2012-06-12 22:49:07.65 spid14s Service Broker manager has started.
2012-06-12 22:49:07.75 登录 错误: 18456，严重性: 14，状态: 16。
2012-06-12 22:49:07.75 登录 Login failed for user 'sa'. ......

[mengmou]

日志内容太少了，看不出啥来。 sql server停掉跟login failed error没关系。

[randomfeel]

2012-06-12 11:24:31.00 spid66 Autogrow of file 'db_log' in database 'db' was cancelled by user or timed out after 203 milliseconds. Use ALTER DATABASE to set a smaller FILEGROWTH value for this file or to explicitly set a new file size.
......
2012-06-12 11:25:09.46 登录 Login failed for user 'sa'. [客户端: xx.xxx.xx.xx]
......
2012-06-12 11:25:10.87 spid14s Service Broker manager has shut down.

[randomfeel]

[Quote=引用 5 楼 的回复:]
检查有无最大内存设置，如果不设置可能会造成内存占用过多而性能下降，不能登陆。
[/Quote]

这个是在哪设置？

[randomfeel]

尝试开AWE，把最大内存改为4G
等等看效果如何

其实如果是内存问题的话。为什么会导致程序连不上数据库，但是同时在数据库里又可以执行查询语句呢（人为进去查日志表）