【以下的问题经过翻译处理】 我正在测试在RDS SQL Server上的关联服务器,用于指向现有的SQL Server(非RDS)。测试连接时出现以下错误消息:
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Named Pipes Provider: Could not open a connection to SQL Server [53].
OLE DB provider "SQLNCLI11" for linked server "GFHSVRHRISDEV01.corp.xyz.co.id" returned message "Login timeout expired".
OLE DB provider "SQLNCLI11" for linked server "GFHSVRHRISDEV01.corp.xyz.co.id" returned message "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.". (Microsoft SQL Server, Error: 53)
我已经验证了网络连通性以及使用EC2进行的域名解析,域名解析正常,并且端口1433的telnet也打开。由于这个RDS集成了托管的Active Directory,我还检查了条件转发是否有效,以查找目标域。
目标数据库也已经配置以接受远程连接。
这可能是什么原因导致的? 我正在寻找进一步排查此问题的任何提示。