- Newest
- Most votes
- Most comments
Hello,
Based on my understanding of the stored procedure called, a linked server was created for SQL Server (on-premises) to RDS SQL Server. The error messages could indicate :
-
Issue with network configuration between the RDS SQL Server Instance and the SQL Server ( on-premises). Please be sure you are allowing traffic from the IP address of the On-premises , as well as on the port that SQL Server is using to listen for database.
-
Or, issue with calling the stored procedure sp_addlinkedserver and sp_addlinkedserverlogin.
I reviewed both called stored procedure and there are no issue detected. Compared to the documentation, the stored procedure you provided is accurate. Therefore, please make sure you are allowing network traffic by using the TCP port through the security group for each inbound instance of SQL Server.
To further look into the DB Instance network configuration, please open a support case with AWS using the following https://console.aws.amazon.com/support/home#/case/create or by following steps in link https://docs.aws.amazon.com/awssupport/latest/user/case-management.html and provide details of the DB Instance endpoint, if used, on-premises source IP.
Relevant content
- AWS OFFICIALUpdated 10 months ago
- AWS OFFICIALUpdated 4 years ago
- AWS OFFICIALUpdated a year ago