很奇怪的错误.
当连接字符串中的IP填写.CWHJF时(服务器名称),就能够连上当填写127.0.0.1或者192.168.100.72的时候就出现错误.
一般性网络错误.DBNETLIB][ConnectionWrite (recv()).]
为啥呢?
当连接字符串中的IP填写.CWHJF时(服务器名称),就能够连上当填写127.0.0.1或者192.168.100.72的时候就出现错误.
一般性网络错误.DBNETLIB][ConnectionWrite (recv()).]
为啥呢?
添加一条IP地址与服务器名称的对应记录,如:
172.168.10.24 myserver
127.0.0.1 CWHJF
192.168.100.72 CWHJF
在最下面添加的,可是还是不行
这个服务器一直都是好的,可能有3个月左右没使用了,今天来就是这样.一直找不到原因/
11/03/2011 12:36:03,spid52,未知,Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the RECONFIGURE statement to install.
11/03/2011 08:48:00,,警告,[396] 尚未定义空闲 CPU 条件 - OnIdle 作业计划将不起任何作用
11/03/2011 08:48:00,,警告,[260] 无法启动邮件会话(原因: 没有定义邮件配置文件)
11/03/2011 08:48:00,,信息,[129] SQLSERVERAGENT 在 Windows NT 服务控制下启动
11/03/2011 08:48:00,,错误,[364] 尚未启动 Messenger 服务 - 将不发送 NetSend 通知
11/03/2011 08:47:59,,信息,[432] 子系统缓存中有 11 个子系统
11/03/2011 08:47:58,spid51,未知,Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
11/03/2011 08:47:58,spid51,未知,Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
11/03/2011 08:47:57,spid51,未知,Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
11/03/2011 08:47:57,,信息,[339] 本地计算机是 CWHJF,运行的是 Windows NT 5.1 (2600) Service Pack 3
11/03/2011 08:47:57,,信息,[310] 检测到 2 个处理器和 988 MB RAM
11/03/2011 08:47:57,,信息,[103] 驱动程序使用的 NetLib 是 DBNETLIB.DLL;本地主机服务器是
11/03/2011 08:47:57,,信息,[102] SQL Server ODBC 驱动程序版本 9.00.1399
11/03/2011 08:47:57,,信息,[101] SQL Server CWHJF 版本 9.00.1399 (连接限制: 0)
11/03/2011 08:47:57,,信息,[100] Microsoft SQLServerAgent 版本 9.00.1399.06 (内部版本号 x86 unicode 零售): 进程 ID 3296
11/03/2011 08:47:45,spid5s,未知,Recovery is complete. This is an informational message only. No user action is required.
11/03/2011 08:47:45,spid5s,未知,Recovery is writing a checkpoint in database 'CRWL' (5). This is an informational message only. No user action is required.
11/03/2011 08:47:45,spid5s,未知,0 transactions rolled back in database 'CRWL' (5). This is an informational message only. No user action is required.
11/03/2011 08:47:44,spid5s,未知,Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
11/03/2011 08:47:44,spid5s,未知,0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
11/03/2011 08:47:44,spid15s,未知,3 transactions rolled forward in database 'CRWL' (5). This is an informational message only. No user action is required.
11/03/2011 08:47:44,spid14s,未知,3 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
11/03/2011 08:47:44,,信息,[393] 正在等待 SQL Server 恢复数据库...
11/03/2011 08:47:43,spid15s,未知,Starting up database 'CRWL'.
11/03/2011 08:47:43,spid14s,未知,Starting up database 'msdb'.
11/03/2011 08:47:42,服务器,未知,SQL Server is now ready for client connections. This is an informational message; no user action is required.
11/03/2011 08:47:42,服务器,未知,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.
11/03/2011 08:47:42,服务器,未知,Dedicated admin connection support was established for listening locally on port 1434.
11/03/2011 08:47:42,服务器,未知,Server is listening on [ 'any' <ipv4> 1434].
11/03/2011 08:47:42,服务器,未知,Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
11/03/2011 08:47:42,服务器,未知,Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
11/03/2011 08:47:42,服务器,未知,Server is listening on [ 'any' <ipv4> 1433].
11/03/2011 08:47:37,spid12s,未知,Service Broker manager has started.
11/03/2011 08:47:36,spid12s,未知,The Database Mirroring protocol transport is disabled or not configured.
11/03/2011 08:47:36,spid12s,未知,The Service Broker protocol transport is disabled or not configured.
11/03/2011 08:47:34,spid9s,未知,Starting up database 'tempdb'.
11/03/2011 08:47:31,服务器,未知,A self-generated certificate was successfully loaded for encryption.
11/03/2011 08:47:30,spid9s,未知,Clearing tempdb database.
11/03/2011 08:47:29,spid9s,未知,Starting up database 'model'.
11/03/2011 08:47:29,spid5s,未知,Server name is 'CWHJF'. This is an informational message only. No user action is required.
11/03/2011 08:47:27,spid5s,未知,Starting up database 'mssqlsystemresource'.
11/03/2011 08:47:27,spid5s,未知,SQL Trace ID 1 was started by login "sa".
11/03/2011 08:47:24,spid5s,未知,Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
11/03/2011 08:47:24,spid5s,未知,0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
11/03/2011 08:47:23,spid5s,未知,6 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
11/03/2011 08:47:21,spid5s,未知,Starting up database 'master'.
11/03/2011 08:47:21,服务器,未知,Database Mirroring Transport is disabled in the endpoint configuration.
11/03/2011 08:47:19,服务器,未知,The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality<c/> please start this service.
11/03/2011 08:47:18,服务器,未知,Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
11/03/2011 08:47:17,服务器,未知,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.
11/03/2011 08:47:15,服务器,未知,Detected 2 CPUs. This is an informational message; no user action is required.
11/03/2011 08:47:15,服务器,未知,SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
11/03/2011 08:47:15,Server,未知,-l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
11/03/2011 08:47:15,Server,未知,-e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
11/03/2011 08:47:15,Server,未知,-d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
11/03/2011 08:47:15,Server,未知,Registry startup parameters:
11/03/2011 08:47:15,Server,未知,This instance of SQL Server last reported using a process ID of 1456 at 2011-11-2 18:02:21 (local) 2011-11-2 10:02:21 (UTC). This is an informational message only; no user action is required.
11/03/2011 08:47:15,Server,未知,Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
11/03/2011 08:47:15,Server,未知,Server process ID is 248.
11/03/2011 08:47:15,Server,未知,All rights reserved.
11/03/2011 08:47:15,Server,未知,(c) 2005 Microsoft Corporation.
11/03/2011 08:47:15,Server,未知,Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) <nl/> Oct 14 2005 00:33:37 <nl/> Copyright (c) 1988-2005 Microsoft Corporation<nl/> Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)2011-11-03 08:47:15.59 Server (c) 2005 Microsoft Corporation.
2011-11-03 08:47:15.59 Server All rights reserved.
2011-11-03 08:47:15.59 Server Server process ID is 248.
2011-11-03 08:47:15.59 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2011-11-03 08:47:15.59 Server This instance of SQL Server last reported using a process ID of 1456 at 2011-11-2 18:02:21 (local) 2011-11-2 10:02:21 (UTC). This is an informational message only; no user action is required.
2011-11-03 08:47:15.59 Server Registry startup parameters:
2011-11-03 08:47:15.59 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2011-11-03 08:47:15.59 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2011-11-03 08:47:15.59 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2011-11-03 08:47:15.71 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2011-11-03 08:47:15.71 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2011-11-03 08:47:17.59 服务器 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.
2011-11-03 08:47:18.15 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2011-11-03 08:47:19.57 服务器 The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2011-11-03 08:47:21.31 服务器 Database Mirroring Transport is disabled in the endpoint configuration.
2011-11-03 08:47:21.32 spid5s Starting up database 'master'.
2011-11-03 08:47:23.40 spid5s 6 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2011-11-03 08:47:24.78 spid5s 0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2011-11-03 08:47:24.78 spid5s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2011-11-03 08:47:27.24 spid5s SQL Trace ID 1 was started by login "sa".
2011-11-03 08:47:27.59 spid5s Starting up database 'mssqlsystemresource'.
2011-11-03 08:47:29.70 spid5s Server name is 'CWHJF'. This is an informational message only. No user action is required.
2011-11-03 08:47:29.71 spid9s Starting up database 'model'.
2011-11-03 08:47:30.31 spid9s Clearing tempdb database.
2011-11-03 08:47:31.12 服务器 A self-generated certificate was successfully loaded for encryption.
2011-11-03 08:47:34.92 spid9s Starting up database 'tempdb'.
2011-11-03 08:47:36.64 spid12s The Service Broker protocol transport is disabled or not configured.
2011-11-03 08:47:36.64 spid12s The Database Mirroring protocol transport is disabled or not configured.
2011-11-03 08:47:37.59 spid12s Service Broker manager has started.
2011-11-03 08:47:42.00 服务器 Server is listening on [ 'any' <ipv4> 1433].
2011-11-03 08:47:42.01 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ].
2011-11-03 08:47:42.01 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ].
2011-11-03 08:47:42.01 服务器 Server is listening on [ 'any' <ipv4> 1434].
2011-11-03 08:47:42.01 服务器 Dedicated admin connection support was established for listening locally on port 1434.
2011-11-03 08:47:42.12 服务器 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.
2011-11-03 08:47:42.12 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required.
2011-11-03 08:47:43.90 spid14s Starting up database 'msdb'.
2011-11-03 08:47:43.93 spid15s Starting up database 'CRWL'.
2011-11-03 08:47:44.64 spid14s 3 transactions rolled forward in database 'msdb' (4). This is an informational message only. No user action is required.
2011-11-03 08:47:44.67 spid15s 3 transactions rolled forward in database 'CRWL' (5). This is an informational message only. No user action is required.
2011-11-03 08:47:44.84 spid5s 0 transactions rolled back in database 'msdb' (4). This is an informational message only. No user action is required.
2011-11-03 08:47:44.84 spid5s Recovery is writing a checkpoint in database 'msdb' (4). This is an informational message only. No user action is required.
2011-11-03 08:47:45.03 spid5s 0 transactions rolled back in database 'CRWL' (5). This is an informational message only. No user action is required.
2011-11-03 08:47:45.03 spid5s Recovery is writing a checkpoint in database 'CRWL' (5). This is an informational message only. No user action is required.
2011-11-03 08:47:45.54 spid5s Recovery is complete. This is an informational message only. No user action is required.
2011-11-03 08:47:57.71 spid51 Using 'xpsqlbot.dll' version '2005.90.1399' to execute extended stored procedure 'xp_qv'. This is an informational message only; no user action is required.
2011-11-03 08:47:58.84 spid51 Using 'xpstar90.dll' version '2005.90.1399' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required.
2011-11-03 08:47:58.98 spid51 Using 'xplog70.dll' version '2005.90.1399' to execute extended stored procedure 'xp_msver'. This is an informational message only; no user action is required.
2011-11-03 12:36:03.90 spid52 Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the RECONFIGURE statement to install.