- 最新
- 最多得票
- 最多評論
There are a few things to check to allow connecting to a linked RDS instance:
-
Make sure the security group of the source RDS instance allows inbound access from the security group of the target RDS instance on the SQL Server port (typically 1433).
-
On the target RDS instance, make sure the public accessibility is not set to "No". It should be set to "Yes" or at least "Yes, and require SSL".
-
For the linked server configuration, specify the DNS name of the target RDS instance, not the IP address.
-
Make sure the master user on the target RDS instance is allowed to connect from the source instance. You may need to create a specific user for the linked server rather than using the RDS master.
-
Double check that the username and password specified in sp_addlinkedserverlogin are correct.
Some key things to verify:
-
Security groups allow communication between the instances
-
Public accessibility on target instance is enabled
-
Use DNS name not IP for datasrc
-
Linked server login has permissions on target
-
Linked login credentials are valid
With those checked, the linked RDS connection should work properly. Let me know if you still have any issues!
相關內容
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 1 年前