AWS RDS for SQL Server simplifies backups, patching, and high availability, but its managed model restricts certain administrative actions — including creating linked servers through the SSMS UI.
If you see errors like “The requested dialog cannot be displayed” or “You must be a member of the sysadmin role”, this is expected. AWS RDS does not provide full sysadmin access, so linked servers must be created using supported system stored procedures.
This article shows how to create linked servers in AWS RDS, query and update remote data, and extend linked servers to SaaS and cloud sources using CData.
👉 Read the full article:
https://www.cdata.com/kb/articles/aws-rds-linked-server.rst
