none
前天服务器挂掉了,sql登陆不上,有日志,帮忙分析下原因 RRS feed

  • 问题

  • 10/28/2014 11:04:56,登录,未知,错误: 18456,严重性: 14,状态: 38。
    10/28/2014 11:04:56,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.140.233]
    10/28/2014 11:04:56,登录,未知,错误: 18456,严重性: 14,状态: 38。
    10/28/2014 11:04:56,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.140.168]
    10/28/2014 11:04:56,登录,未知,错误: 18456,严重性: 14,状态: 38。
    10/28/2014 11:04:56,登录,未知,Login failed for user 'sa'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.110.226]
    10/28/2014 11:04:56,登录,未知,错误: 18456,严重性: 14,状态: 38。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.140.89]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.110.134]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.110.164]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.111.100]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.140.104]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:56,登录,未知,SQL Server is not ready to accept new client connections. Wait a few minutes before trying again. If you have access to the error log<c/> look for the informational message that indicates that SQL Server is ready before trying to connect again.  [客户端: 192.168.140.59]
    10/28/2014 11:04:56,登录,未知,错误: 17187,严重性: 16,状态: 1。
    10/28/2014 11:04:55,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
    10/28/2014 11:04:55,服务器,未知,The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. 
    Error: 0x54b<c/> state: 3. 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.
    10/28/2014 11:04:55,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
    10/28/2014 11:04:55,服务器,未知,Server is listening on [ 127.0.0.1 <ipv4> 1434].
    10/28/2014 11:04:55,服务器,未知,Server is listening on [ ::1 <ipv6> 1434].
    10/28/2014 11:04:55,服务器,未知,Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
    10/28/2014 11:04:55,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
    10/28/2014 11:04:55,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
    10/28/2014 11:04:55,服务器,未知,Server is listening on [ 'any' <ipv6> 1433].
    10/28/2014 11:04:55,服务器,未知,A self-generated certificate was successfully loaded for encryption.
    10/28/2014 11:04:54,spid10s,未知,Clearing tempdb database.
    10/28/2014 11:04:54,spid7s,未知,Server name is 'SERVER01'. This is an informational message only. No user action is required.
    10/28/2014 11:04:54,spid10s,未知,Starting up database 'model'.
    10/28/2014 11:04:53,spid7s,未知,The resource database build version is 10.50.1600. This is an informational message only. No user action is required.
    10/28/2014 11:04:53,spid7s,未知,Starting up database 'mssqlsystemresource'.
    10/28/2014 11:04:53,spid7s,未知,SQL Trace ID 1 was started by login "sa".
    10/28/2014 11:04:53,spid7s,未知,FILESTREAM: effective level = 0<c/> configured level = 0<c/> file system access share name = 'MSSQLSERVER'.
    10/28/2014 11:04:53,spid7s,未知,SQL Server Audit has started the audits. This is an informational message. No user action is required.
    10/28/2014 11:04:53,spid7s,未知,SQL Server Audit is starting the audits. This is an informational message. No user action is required.
    10/28/2014 11:04:53,spid7s,未知,Resource governor reconfiguration succeeded.
    10/28/2014 11:04:52,spid7s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
    10/28/2014 11:04:52,spid7s,未知,0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
    10/28/2014 11:04:52,spid7s,未知,399 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
    10/28/2014 11:04:51,spid7s,未知,Starting up database 'master'.
    10/28/2014 11:04:51,服务器,未知,Node configuration: node 0: CPU mask: 0x000000000000ffff:0 Active CPU mask: 0x000000000000ffff:0. 
    This message provides a description of the NUMA configuration for this computer. 
    This is an informational message only. No user action is required.
    10/28/2014 11:04:50,服务器,未知,Lock partitioning is enabled.  This is an informational message only. No user action is required.
    10/28/2014 11:04:50,服务器,未知,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.
    10/28/2014 11:04:49,服务器,未知,Using locked pages for buffer pool.
    10/28/2014 11:04:49,Server,未知,Large Page Allocated: 32MB
    10/28/2014 11:04:49,Server,未知,Large Page Granularity: 2097152
    10/28/2014 11:04:49,Server,未知,Large Page Extensions enabled.
    10/28/2014 11:04:49,服务器,未知,Detected 16 CPUs. This is an informational message; no user action is required.
    10/28/2014 11:04:49,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
    10/28/2014 11:04:49,Server,未知,Registry startup parameters: <nl/> -d C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\master.mdf<nl/> -e C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG<nl/> -l C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
    10/28/2014 11:04:49,Server,未知,This instance of SQL Server last reported using a process ID of 7152 at 2014/10/28 10:49:53 (local) 2014/10/28 2:49:53 (UTC). This is an informational message only; no user action is required.
    10/28/2014 11:04:49,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\ERRORLOG'.
    10/28/2014 11:04:49,Server,未知,Authentication mode is MIXED.
    10/28/2014 11:04:49,Server,未知,System Manufacturer: 'IBM'<c/> System Model: 'IBM 3850 M2 / x3950 M2 -[7233RVC]-'.
    10/28/2014 11:04:49,Server,未知,Server process ID is 1832.
    10/28/2014 11:04:49,Server,未知,All rights reserved.
    10/28/2014 11:04:49,Server,未知,(c) Microsoft Corporation.
    10/28/2014 11:04:49,Server,未知,Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) <nl/> Apr  2 2010 15:48:46 <nl/> Copyright (c) Microsoft Corporation<nl/> Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2)
    10/28/2014 02:52:15,备份,未知,Database backed up. Database: YXYKT<c/> creation date(time): 2014/04/14(18:43:18)<c/> pages dumped: 30218<c/> first LSN: 3262:44:161<c/> last LSN: 3262:110:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\databak\YXYKT_backup_2014_10_28_001001_6019563.bak'}). This is an informational message only. No user action is required.
    2014年10月29日 8:49

全部回复