SQL Server on RDS Issue With Linked Server

0

I'm testing Linked Server on RDS SQL Server to point to existing SQL Server (non RDS). Test connection throw error with the following message :

------------------------------
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 "SQLNCLIThe test connection to the linked server failed.
11" 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)

I have validated the network connectivity as well as domain name resolution using EC2, domain resolution works, telnet to port 1433 also open. As this RDS integrated with the Managed Active Directory, I have also checked that the Conditional Forwarding works to lookup target domain.

The target database also already configured to accept remote connection.

What would be the possible root cause for this? I'm looking for any hints to further troubleshoot this issue.

AWS
エキスパート
Tedy_T
質問済み 4年前1140ビュー
1回答
0
承認された回答

In addition to checking whether Named Pipes are configured, verify that the server name is resolvable from the device initiating the connection, verify port 1433 and 1434 are permitted inbound from the device you are testing from, and also verify that outbound communication is permitted for return traffic i.e. ephemeral ports are open outbound and also permitted by any firewalls in between. A more simplistic way to test is to leverage UDL files to test connectivity documented here - https://docs.microsoft.com/en-us/sql/connect/oledb/help-topics/data-link-pages?view=sql-server-ver15

AWS
回答済み 4年前
profile picture
エキスパート
レビュー済み 15日前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン