用于SQL Server的ODBC驱动程序17 - 链接服务器失败 [英] ODBC Driver 17 for SQL Server - Linked Server Fails
问题描述
用于SQL Server的ODBC驱动程序17 - 链接服务器故障
ODBC Driver 17 for SQL Server - Linked Server failure
我遇到问题，我的链接服务器工作了大约12分钟然后失败。 抱歉，此时我没有失败消息，但明天我可以得到它
I have a problem where my linked server works for about 12 minutes and then fails. Sorry I do not have the failure message at this point, but I can get it tomorrow
我有一个Windows 2012 Server并安装了SQL Server 2014 SP3。
I have a Windows 2012 Server and have SQL Server 2014 SP3 Installed.
我需要为另一个SQL Server实例提供链接服务器，我必须设置的方法是使用连接到远程服务器的服务器上的原始"SQL Server"ODBC驱动程序创建系统DSN连接服务器，然后我创建
a链接服务器使用Microsoft OLE DB Provider for ODBC提供程序到该系统DSN
I have a requirement to provide a linked server to another SQL Server instance and the way I had to set it up was to create a system DSN connection using the original "SQL Server" ODBC drivers on my server connecting to the remote server and then I created a linked server using the Microsoft OLE DB Provider for ODBC provider to that system DSN
在TLS 1.2成为必需之前，这项工作正常多年。 为了处理TLS 1.2我安装了SQL Server的ODBC驱动程序17。 然后我创建了一个新的DSN连接并重新启动了实例，并且链接服务器测试正常。
This was working fine for many years until TLS 1.2 became required. To deal with TLS 1.2 I installed the ODBC Driver 17 for SQL Server. I then created a new DSN connection and restarted the instance and the linked server tested fine.
问题是大约12分钟后链接服务器出现故障 - 抱歉我没有错误消息，但它的某些内容无法使用ODBC驱动程序17连接到SQL服务器。 如果我重新启动实例，链接服务器将再次运行
大约10分钟并失败。
The problem is that after about 12 minutes the Linked server fails – sorry I do not have the error message, but its something about cannot connect using the ODBC driver 17 for SQL server. If I restart the instance the linked server will work again for about 10 minutes and fail.
我修复它的方式是我使用ODBC驱动程序创建了DSN连接11 for SQL server - 它支持TLS 1.2就好了，链接服务器在10分钟后没有失败。 事实上，我可以让链接服务器工作，甚至不用
重新启动实例。
The way I fixed it was I created the DSN connection using the ODBC Driver 11 for SQL server – it supports TLS 1.2 just fine and the linked server did not fail after 10 minutes. As a matter of fact, I could get the linked server to work without even having to restart the instance.
我的问题是为什么链接服务器在10之后失败几分钟使用ODBC驱动程序17 for SQL server。
My question is why does the linked server fail after 10 minutes using the ODBC Driver 17 for SQL server.
感谢任何帮助。
Any help is appreciated.
推荐答案
以下是尝试测试链接服务器时的错误
Below is the error when trying to test the linked server
------------------------------
$
与链接服务器的测试连接失败。
------------------------------
附加信息：
执行Transact-SQL语句或批处理时发生异常。 （Microsoft.SqlServer.ConnectionInfo）
------------------------------
无法初始化OLE DB提供程序的数据源对象"MSDASQL"。对于链接服务器"LinkedServerNamehere"。
OLE DB提供程序"MSDASQL"对于链接服务器"LinkedServerNamehere"返回消息"[Microsoft] [SQL Server的ODBC驱动程序17]建立与SQL Server的连接时发生了与网络相关或特定于实例的错误。
找不到服务器或无法访问服务器。检查实例名称是否正确以及SQL Server是否配置为允许远程连接。有关详细信息，请参阅SQL Server联机丛书。"。
OLE DB提供程序"MSDASQL"对于链接服务器"LinkedServerNamehere"返回消息"[Microsoft] [用于SQL Server的ODBC驱动程序17]客户端无法建立连接"。
OLE DB提供程序"MSDASQL"对于链接服务器"LinkedServerNamehere"返回消息"[Microsoft] [SQL Server的ODBC驱动程序17]客户端不支持加密。" （Microsoft SQL Server，错误：7303）
------------------------------
The test connection to the linked server failed.
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "LinkedServerNamehere".
OLE DB provider "MSDASQL" for linked server "LinkedServerNamehere" returned message "[Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.".
OLE DB provider "MSDASQL" for linked server "LinkedServerNamehere" returned message "[Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection".
OLE DB provider "MSDASQL" for linked server "LinkedServerNamehere" returned message "[Microsoft][ODBC Driver 17 for SQL Server]Encryption not supported on the client.". (Microsoft SQL Server, Error: 7303)
这篇关于用于SQL Server的ODBC驱动程序17 - 链接服务器失败的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
