AWS re:Post을(를) 사용하면 다음에 동의하게 됩니다. AWS re:Post 이용 약관
AWS re:Postre:Post

RDS MS SQL server ODBC Linked server connection issues

0

we tried using the SSMS console to add linked servers but the admin user does not have Sys admin access to add linked servers. so we tried using the sp_addlinkedserver from this article: https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/ https://aws.amazon.com/premiumsupport/knowledge-center/rds-sql-server-create-linked-server/ but have still been unsuccessful. our linked servers are ODBCs and can connect in localhost easily Please help

주제
데이터베이스마이그레이션 및 현대화분석
태그
마이크로소프트 SQL 서버아마존 Relational Database Service데이터베이스
언어
English
werner-oscar
질문됨 일 년 전470회 조회
1개 답변
0

Hi,

Thanks for reaching out to us via AWS re:Post - the links that you have referred are the correct ones. sysadmin is not needed to create linked servers here. If you can share more details on the error that would help. Also - this may require an engineer from support to deep dive.

Note-> Linked Server is supported for only SQL Server (EC2 or on-premises) to RDS SQL Server RDS SQL Server to SQL Server (RDS, EC2, or on-premises)

Hope this helps. Have a great rest of the day!

P.S.- maybe this will help https://stackoverflow.com/questions/64617084/sql-server-add-a-linked-server-to-aws-rds-instance

AWS
전문가
NIRUPAM_d
답변함 일 년 전
  • Sanjeev_K
    일 년 전

    Hi,

    I think RDS SQL Server now supports the linked servers to Oracle also, right

    RDS SQL Server ----> EC2, RDS SQL Server, On-premises SQL server and On-premises Oracle,

    Maybe we have limitations like, only Oracle 21 above versions support etc..

    Please check and update

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠