SqlException &定时器作业
我发现下面的 ULS 日志条目是计时器作业 (OWSTimer.EXE) 导致的,但是我想知道计时器作业的名称,我该如何实现这一点? (不启用详细日志记录)
System.Data.SqlClient.SqlException:A 与网络相关或特定于实例的 建立时发生错误 连接到 SQL Server。服务器 未找到或无法访问。 验证实例名称是否为 正确并且 SQL Server 是 配置为允许远程 连接。
SqlError: '与网络相关或 发生特定于实例的错误 建立与 SQL 的连接 服务器。找不到服务器或 无法访问。验证 实例名称正确且 SQL 服务器配置为允许远程 连接。 (提供者:TCP 提供者, 错误:0 - 等待操作计时 出。)'来源:'.Net SqlClient 数据 提供商编号:258 州:0 类别: 20 过程:'' 行号:0 服务器: ''
I found the below ULS Log entries, Timer job (OWSTimer.EXE) is causing this however would like to know the name of the Timer-job, how can i achieve this? (without enabling verbose logging)
System.Data.SqlClient.SqlException: A
network-related or instance-specific
error occurred while establishing a
connection to SQL Server. The server
was not found or was not accessible.
Verify that the instance name is
correct and that SQL Server is
configured to allow remote
connections.SqlError: 'A network-related or
instance-specific error occurred while
establishing a connection to SQL
Server. The server was not found or
was not accessible. Verify that the
instance name is correct and that SQL
Server is configured to allow remote
connections. (provider: TCP Provider,
error: 0 - The wait operation timed
out.)' Source: '.Net SqlClient Data
Provider' Number: 258 State: 0 Class:
20 Procedure: '' LineNumber: 0 Server:
''
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您可以尝试使用像wireshark这样的工具来查看正在生成什么类型的网络流量以及在哪个帐户下发出请求以及正在向哪个SQL框发出请求。我怀疑此错误是通过以下方式之一触发的(前 2 个不太可能的方式,然后是可能的问题):
You could try using a tool like wireshark to see what kind of network traffic is being generated and under which account a request and to which SQL box is being made. I suspect this error is triggered one of the following ways (first 2 unlikely ones, then the likely problem):