首页>问答区>求解,客户端能ping通但是连不上SQL SERVER数据库

求解,客户端能ping通但是连不上SQL SERVER数据库

  • 1回答
  • 564浏览
客户端能ping通但是连不上SQL SERVER数据库,求解啊大佬们 [code]2021-05-31 14:27:03.45 Server Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 (Build 9200: ) 2021-05-31 14:27:03.46 Server (c) Microsoft Corporation. 2021-05-31 14:27:03.46 Server All rights reserved. 2021-05-31 14:27:03.47 Server Server process ID is 6564. 2021-05-31 14:27:03.47 Server System Manufacturer: 'LENOVO', System Model: 'ThinkServer TS250'. 2021-05-31 14:27:03.47 Server Authentication mode is MIXED. 2021-05-31 14:27:03.47 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG'. 2021-05-31 14:27:03.47 Server This instance of SQL Server last reported using a process ID of 1520 at 2021/5/31 14:26:51 (local) 2021/5/31 6:26:51 (UTC). This is an informational message only; no user action is required. 2021-05-31 14:27:03.47 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf 2021-05-31 14:27:03.47 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2021-05-31 14:27:03.47 服务器 Detected 4 CPUs. This is an informational message; no user action is required. 2021-05-31 14:27:03.47 Server Cannot use Large Page Extensions: lock memory privilege was not granted. 2021-05-31 14:27:03.51 服务器 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. 2021-05-31 14:27:03.53 服务器 Node configuration: node 0: CPU mask: 0x000000000000000f:0 Active CPU mask: 0x000000000000000f:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required. 2021-05-31 14:27:03.55 spid7s Starting up database 'master'. 2021-05-31 14:27:03.63 spid7s Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required. 2021-05-31 14:27:03.73 spid7s Resource governor reconfiguration succeeded. 2021-05-31 14:27:03.73 spid7s SQL Server Audit is starting the audits. This is an informational message. No user action is required. 2021-05-31 14:27:03.73 spid7s SQL Server Audit has started the audits. This is an informational message. No user action is required. 2021-05-31 14:27:03.73 spid7s FILESTREAM: effective level = 0, configured level = 0, file system access share name = 'MSSQLSERVER'. 2021-05-31 14:27:03.77 spid7s SQL Trace ID 1 was started by login "sa". 2021-05-31 14:27:03.77 spid7s Starting up database 'mssqlsystemresource'. 2021-05-31 14:27:03.81 spid7s The resource database build version is 10.50.1600. This is an informational message only. No user action is required. 2021-05-31 14:27:03.88 spid10s Starting up database 'model'. 2021-05-31 14:27:03.88 spid7s Server name is 'ERP'. This is an informational message only. No user action is required. 2021-05-31 14:27:03.98 spid10s Clearing tempdb database. 2021-05-31 14:27:03.99 服务器 A self-generated certificate was successfully loaded for encryption. 2021-05-31 14:27:03.99 服务器 Server is listening on [ 'any' 1433]. 2021-05-31 14:27:03.99 服务器 Server is listening on [ 'any' 1433]. 2021-05-31 14:27:03.99 服务器 Server local connection provider is ready to accept connection on [ \\.\pipe\SQLLocal\MSSQLSERVER ]. 2021-05-31 14:27:03.99 服务器 Server named pipe provider is ready to accept connection on [ \\.\pipe\sql\query ]. 2021-05-31 14:27:04.00 服务器 Server is listening on [ ::1 1434]. 2021-05-31 14:27:04.00 服务器 Server is listening on [ 127.0.0.1 1434]. 2021-05-31 14:27:04.00 服务器 Dedicated admin connection support was established for listening locally on port 1434. 2021-05-31 14:27:04.00 服务器 The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL Server service. Error: 0x54b, 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. 2021-05-31 14:27:04.00 服务器 SQL Server is now ready for client connections. This is an informational message; no user action is required. 2021-05-31 14:27:04.01 登录 错误: 18456,严重性: 14,状态: 38。 2021-05-31 14:27:04.01 登录 Login failed for user 'ERP\Administrator'. 原因: 无法打开明确指定的数据库。 [客户端: ] 2021-05-31 14:27:04.12 登录 错误: 18456,严重性: 14,状态: 38。 2021-05-31 14:27:04.12 登录 Login failed for user 'ERP\Administrator'. 原因: 无法打开明确指定的数据库。 [客户端: 192.168.27.250] 2021-05-31 14:27:04.15 spid10s Starting up database 'tempdb'. 2021-05-31 14:27:04.24 spid14s The Service Broker protocol transport is disabled or not configured. 2021-05-31 14:27:04.24 spid14s The Database Mirroring protocol transport is disabled or not configured. 2021-05-31 14:27:04.25 spid14s Service Broker manager has started. 2021-05-31 14:27:04.58 spid13s A new instance of the full-text filter daemon host process has been successfully started. 2021-05-31 14:27:04.64 spid21s Starting up database 'ReportServer'. 2021-05-31 14:27:04.64 spid13s Starting up database 'msdb'. 2021-05-31 14:27:04.64 spid22s Starting up database 'ReportServerTempDB'. 2021-05-31 14:27:04.64 spid23s Starting up database 'ERP'. 2021-05-31 14:27:04.64 spid24s Starting up database 'TEST'. 2021-05-31 14:27:05.76 spid7s Recovery is complete. This is an informational message only. No user action is required. 2021-05-31 14:27:43.14 登录 错误: 18456,严重性: 14,状态: 8。 2021-05-31 14:27:43.14 登录 Login failed for user 'sa'. 原因: 密码与所提供的登录名不匹配。 [客户端: ] 2021-05-31 14:27:45.96 登录 错误: 18456,严重性: 14,状态: 8。 2021-05-31 14:27:45.96 登录 Login failed for user 'sa'. 原因: 密码与所提供的登录名不匹配。 [客户端: ] 2021-05-31 14:27:48.60 登录 错误: 18456,严重性: 14,状态: 8。 2021-05-31 14:27:48.60 登录 Login failed for user 'sa'. 原因: 密码与所提供的登录名不匹配。 [客户端: ] 2021-05-31 14:28:04.68 spid53 Attempting to load library 'xpstar.dll' into memory. This is an informational message only. No user action is required. 2021-05-31 14:28:04.72 spid53 Using 'xpstar.dll' version '2009.100.1600' to execute extended stored procedure 'xp_instance_regread'. This is an informational message only; no user action is required. 2021-05-31 20:21:59.18 登录 错误: 18456,严重性: 14,状态: 8。 2021-05-31 20:21:59.18 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 00:00:12.70 spid27s This instance of SQL Server has been using a process ID of 6564 since 2021/5/31 14:27:05 (local) 2021/5/31 6:27:05 (UTC). This is an informational message only; no user action is required. 2021-06-01 10:32:55.52 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 10:32:55.52 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 10:33:02.07 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 10:33:02.07 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 10:33:05.76 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 10:33:05.76 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 13:31:19.63 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:31:19.63 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 13:32:16.51 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:32:16.51 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.249] 2021-06-01 13:32:18.14 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:32:18.14 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.249] 2021-06-01 13:32:38.20 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:32:38.20 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.249] 2021-06-01 13:33:55.51 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:33:55.51 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] 2021-06-01 13:34:01.04 登录 错误: 18456,严重性: 14,状态: 8。 2021-06-01 13:34:01.04 登录 Login failed for user '张晓云'. 原因: 密码与所提供的登录名不匹配。 [客户端: 192.168.27.42] [/code]
展开
收起
gongpan02262021-06-02

最佳答案

oswica 2021-06-07回答
telnet sqlserver的端口1433 看看

热门问答

求解答 为什么第一次可以改第二次错了。将姓名小白改为小蓝 在改为小红
  • 1回答
  • 48808浏览
仔细看错误提示,在mysql这几个字母处出现了问题,很明显你是在命令行使用键盘向上箭头复现的语句,怕出问题直接复制粘贴在执行
oracle修改sys用户密码报错
  • 2回答
  • 46582浏览
密码中不要带 [color=#ff0000][b]&[/b][/color] 字符。
风哥Oracle数据库视频培训教程大合集(网盘下载.共18套)
  • 8回答
  • 41639浏览
oracle我想学
需求局域网电脑上的文件定时备份到服务器有什么好的方法?大神们
  • 9回答
  • 38867浏览
我是以批处理实现的 实例: 一同事用的电脑编号是 057 服务器IP地址为:192.168.1.5, 1. 在服务器上添加用户057, 密码设为057@345678,服务器上建一文件夹“bak”,”,Bak下建一文件夹"057$", [u]057$[/u]文件夹共享并 设置权限,只让057用户访问读写 2. 在057电脑上,c:\下,建一文件夹 "BF" BF中放入两个批处理文件: WP.BAT与BF.BAT WP.BAT内容如下(将服务器上文件夹057$映射成自已电脑上的一个网盘) @echo off net use n: \\192.168.1.5\057$ 057@345678 /user:057 reg add HKCU\Software\Microsoft\Windows\CurrentVersion\Explorer\MountPoints2\##192.168.1.5#057$ /v _LabelFromReg /d "备份网盘" /f BF.BAT内容如下(拷贝本机E盘下所有文件到服务器上的057$文件夹中,请按你实际需求修改) @echo off mode con cols=80 lines=40 color 71 title 备份程序 (从本机到服务器) 啸洪 @echo on @echo . @xcopy e:\*.* n:\e\*.* /h /r /y /e /k /v /c /d @echo . @echo . @echo . @echo %date% @echo . @echo E盘,已备份至服务器,复制已完成! @echo . @echo . @echo . @echo OFF PAUSE 3. 在计划任务中添加 WP.BAT为每次登陆时执行; BF.BAT为每天中午执行 4.将C:\BF 文件夹,加入安全软件,如360卫士的信任区 仍有不明白处,加joshual 啸洪交流[[i] 本帖最后由 joshualv 于 2020-6-6 10:35 编辑 [/i]]
有没有哪位大神有lldp讲解视频,求分享
  • 1回答
  • 38145浏览
[baiyan] [baiyan] [baiyan] [baiyan]
麻烦大神帮忙优化一下语句,现在很慢
  • 5回答
  • 36427浏览
INNER JOIN 用太多了 只有其中一個TABLE JOIN起來為NULL都會很慢 改成 select * from tableA a left join tableB b on a.ID = b.ID where b.ID IS NOT NULL[[i] 本帖最后由 johnson223 于 2019-10-16 17:02 编辑 [/i]]
零基础学oracle
  • 2回答
  • 36099浏览
< img class="cto- img" src="http://image1.8264.com/forum/202003/14/073145vqbo4ph6li3q2t0a.png!t3w825h0x9m1" > < img class="cto- img" src="http://image1.8264.com/forum/202003/14/073221wwsq4gh1h7mawyrm.png!t3w825h0x9m1" > < img class="cto- img" src="http://image1.8264.com/forum/202003/14/073319n82hm5p65b39gu3s.png!t3w825h0x9m1" > < img class="cto- img" src="http://image1.8264.com/forum/202003/14/073344pzhzsj9f84bk3xnp.png!t3w825h0x9m1" > < img class="cto- img" src="http://image1.8264.com/forum/202003/14/073457atxy1k17ia4bwulx.png!t3w825h0x9m1" >
mysql主从延时怎么解决?
  • 2回答
  • 31870浏览
造成主从延迟的原因有很多,先根据自己公司的实际环境,找到对应的瓶颈,才能更好的解决。比如网络带宽、主从库配置差异与服务器对外提供服务造成的压力、不合规的SQL 等等。
超融合
  • 6回答
  • 31543浏览
[color=#ff0000] [/color] [color=#ff0000]第一份是一个经销商给出的超融合方案的报价清单,方案用的是NUTANIX,中文是路坦力。[/color] [color=#ff0000]第二份是内地另一个超融合厂商对其指出的劣势。不过这些反驳有些苍白无力。厂商是深信服。[/color]
MYSQL的表中一列的上上一行与上一行的字拼接后填入到本行中
  • 1回答
  • 30671浏览
专注于与个人游戏开发者合作,有产品的朋友××××××,详聊