Summary

This pattern describes how to access on-premises Microsoft SQL Server database tables running on Microsoft Windows, from Microsoft SQL Server databases running or hosted on Amazon Elastic Compute Cloud (Amazon EC2) Windows or Linux instances by using linked servers.

Prerequisites and limitations

Prerequisites

• An active AWS account

• Amazon EC2 with Microsoft SQL Server running on Amazon Linux AMI (Amazon Machine Image)

• AWS Direct Connect between the on-premises Microsoft SQL Server (Windows) server and the Windows or Linux EC2 instance

Product versions

• SQL Server 2016 or later

Architecture

Source technology stack

• On-premises Microsoft SQL Server database running on Windows

• Amazon EC2 with Microsoft SQL Server running on Windows AMI or Linux AMI

Target technology stack

• Amazon EC2 with Microsoft SQL Server running on Amazon Linux AMI

• Amazon EC2 with Microsoft SQL Server running on Windows AMI

Source and target database architecture

https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/access-on-premises-microsoft-sql-server-tables-from-microsoft-sql-server-on-amazon-ec2-using-linked-servers.html?did=pg_card&trk=pg_card