Microsoft SQL Server Management Studio (SSMS) will default connect to port 1421 and there’s not obvious way to changing the port number. However it is possible by using a comma in the server name.
So in the example:
database-1.eu-west-1.rds.amazonaws.com,1521
First the server name, then a comma, and then the port number.
servername,portnumber