How do I correctly create a linked-server entry, from an on-prem SQL Server, to an AWS RDS SQL Server instance? On-prem is 2008 R2, AWS-RDS is running 2012.
This is the error I get when attempting to SELECT from a table in the linked-server:
OLE DB provider "SQLNCLI10" for linked server "RDS-Q1-LINK" returned message "Unable to complete login process due to delay in opening server connection". Msg 7303, Level 16, State 1, Line 30 Cannot initialize the data source object of OLE DB provider "SQLNCLI10" for linked server "RDS-Q1-LINK".
I have tried following instructions here and people in the thread say they've got it working (from on-prem to AWS, not the reverse, which I don't care about), but nobody specified exactly how they did it or what work-arounds or gotchas they encountered. Another article says the same thing -- they've "had success LINKING TO RDS" but they fail to specify how.