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.
- 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: