Connectivity error while connect in AWS SQL Server

A network related or instance specific error occurred while establishing a connection to SQL Server in AWS

Created a new SQL Server in AWS environment. While trying to connect having following issue in connectivity from SQL Server Management studio from local machine.

Cause: Enable the inbound connectivity in Security group or check the publicity accessible option should be yes.

Solution:

  1. Check the publicity accessible option otherwise make it yes:

2. Add the inbound connection setting in security group for port 1433. Go to the security group setting in AWS console–>RDS.

Add the new row to enable TCP port 1433 for inbound connectivity for SQL Server: