解决SQL Server 2016的间歇性连接问题 [英] Troubleshooting intermittent connection issue to SQL Server 2016

问题描述

您好b $ b $
我们的SQL Server 2016遇到了一个奇怪的间歇性连接问题，我们正在不时收到应用服务器端的问题错误：

建立与SQL Server的连接时发生网络相关或特定于实例的错误，找不到服务器..



我使用一个小的.net工具面临同样的间歇性问题，我们使用连接字符串作为参数来测试与SQL服务器的连接，我们知道这不是DNS解决问题，因为我们正面临使用IP的问题另外，奇怪的
是我们无法使用UDL文件，SQLCMD工具或从ODBC测试连接表单重现问题




应用程序的一些组件使用ODBC和其他JDBC，我更新了所有JDBC，ODBC，Native客户端驱动程序。


SQL服务器或Windows日志中没有错误，我们的管理员唯一可以看到的是他们捕获的这个错误使用netsh工具：
$
创建，状态：状态访问被拒绝，文件名：sql \query



我已阅读大部分主题和文章我发现与SQL Server的通信问题有关，没有任何内容适用于我们的案例





Environnement：

应用服务器：Windows Server 2016 .net 4.5

SQL Server：Windows Server 2016 .net 4.5 + SQL 2016 SP2
$


任何反馈意见如何解决此问题？

祝你好运

  

---

Mohamed B。

解决方案

该错误是通用的"无法连接到服务器"消息并没有帮助以任何方式诊断实际问题。

您所描述的内容几乎总是与某种网络问题有关。 您可以尝试使用wireshark或其他东西捕获网络流量，并尝试确定失败期间究竟发生了什么。

Hi

We have facing a strange intermittent connection issue to one of our SQL Server 2016, on app server side from time to time we are receiving the error:
A network-related or instance-specific error occurred while establishing connection to SQL Server, the server was not found ..

I am facing the same intermittent issue with a small .net tool we created that test a connection to SQL server using a connection string as a param, we know that this is not a DNS resolution issue since we are facing the issue using the IP adr too, the strange thing is we are not able to reproduce the issue using UDL file, SQLCMD tool or from the ODBC test connection form

Some componenets of the application are using ODBC and others JDBC and I have updated all JDBC, ODBC, Native clients drivers

No errors in SQL server or windows logs, the only thing that our admin can see is this error they captured using netsh tool:
Create, Status: Status Access denied, filename: sql\query

I have read most of threads and articles I can find related to communication issue with SQL Server and nothing is applying to our case


Environnement:
App server : Windows Server 2016 .net 4.5
SQL Server : Windows Server 2016 .net 4.5 + SQL 2016 SP2

Any feedback on how to resolve this issue ?

Best regards

  

---

Mohamed B.

解决方案

That error is a generic "cannot connect to server" message and does not help diagnose the actual problem in any way.

What you describe is almost always related to a network issue of some kind.  You could try using wireshark or something to capture network traffic and try to determine what exactly is happening during the failure.

这篇关于解决SQL Server 2016的间歇性连接问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！