- Le plus récent
- Le plus de votes
- La plupart des commentaires
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!
Contenus pertinents
- demandé il y a 4 mois
- demandé il y a un an
- demandé il y a 5 mois
- demandé il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 2 ans