question

KelvinShee-2603 avatar image
0 Votes"
KelvinShee-2603 asked Cathyji-msft commented

SQL Server 2019 Cluster on AWS EC2 Port Allow

hi please help, I setup SQL Server Cluster on EC2, may I know what is the SQL Server Cluster port number that I need allow in security group when windows firewall is enable?

I been allow port
TCP 135,1433,3343
UDP 137,3343

but is still failed to connect cluster?

do any port that I miss setup? thanks.

sql-server-general
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Maybe it is better to ask this question in a Amazon forum related to AWS?

0 Votes 0 ·

AWS support also searching from Microsoft

0 Votes 0 ·

1 Answer

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft commented

Hi @KelvinShee-2603,

Try to allow port UDP 1434.

Quote from MS document Ports Used By the Database Engine.

By default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

I try those port but is not working.
By default, the typical ports used by SQL Server and associated database engine services are: TCP 1433, 4022, 135, 1434, UDP 1434.


those the port I allow is finally working.
TCP
135, 139, 443, 445, 1433-1434, 5022, 7022

UDP
135, 137-138, 445, 1434, 3343, 5000-5099, 8011-8031

0 Votes 0 ·

Hi @KelvinShee-2603,

I am so glad to hear that your issue has been resolved. Thanks for sharing the solution. It will benefit all community members who are having this similar issue.

0 Votes 0 ·