How to connect AWS ECS Service to database in EC2 instance?

Question

I have a SQL Server database running on Windows Server EC2 instance. I also have Web API (ASP.NET Core WebAPI) deployed as a Service in ECS cluster (Fargate launch type).

What connection string should I use to access this database from my web API?

Right now I'm trying:

data source=NAME_OF_THE_EC2_INSTANCE;initial catalog=DATABASE_NAME;User Id=USER_NAME;Password=PASSWORD;MultipleActiveResultSets=True;App=EntityFramework;Connection Timeout=10;

But it doesn't work. The error returned suggests that the app doesn't even see the database at all.

Have you verified the security groups associated with the Tasks and the EC2 instance which hosts the Database. — Sandesh, Feb 04 '20 at 07:18
also check that the windows firewall lets traffic through for sql server ports 1433 and 1434. — James Woolfenden, Feb 04 '20 at 07:45

score 0 · Answer 1 · answered May 28 '20 at 11:03

It seems you'll need to use a NAT instance/Gateway This will enable connectivity between your Fargate instance and EC2 instance where DB is installed.

Another source and also the official documentation

"...Container instances need external network access to communicate with the Amazon ECS service endpoint, so if your container instances are running in a private VPC, they need a network address translation (NAT) instance to provide this access. For more information, see NAT Instances in the Amazon VPC User Guide."

How to connect AWS ECS Service to database in EC2 instance?

1 Answers1