By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

Using Aurora Postgres with MSSQL Linked Server

0

Is it possible to setup a linked server connection between Aurora or RDS (PostgreSQL) and an on-prem MSSQL server using Windows authentication with the on-prem Active Directory (and its AD-Connector on AWS)? The purpose of this setup is for ongoing work, not a migration, and ideally, we would like to create a single connection to the AWS database which will in turn query the on-prem DB and fetch data from there for our query.

I am familiar with this blog post: https://aws.amazon.com/blogs/database/implement-linked-servers-with-amazon-rds-for-microsoft-sql-server/ but it doesn't mention Windows Authentication.

Thanks!

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceAurora PostgreSQL
Language
English
rePost-User-5941005
asked a year ago273 views
1 Answer
1
Accepted Answer

You may want to check out if the tds_fdw extension is supported on your Aurora PostgreSQL version: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Extensions.html#AuroraPostgreSQL.Extensions.14

There are examples showing you how to connect to a Microsoft SQL Server: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.Extensions.foreign-data-wrappers.html#postgresql-tds-fdw

Good luck!

robcube
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content