Wanted to see what it will take to access our RDS Server via its IP Address as different from accessing through the FQDN.
RDS Home Page
Access our region specific RDS Home page ( https://us-west-2.console.aws.amazon.com/rds/home?region=us-west-2#dbinstances: ).
Get Matching IP Address
Validated that we are able to access the SQL Server Instance using the FQDN’s IP Address
What is the Server’s actual IP Address?
Dynamic Management View
SELECT [Machine Name] = SERVERPROPERTY('ComputerNamePhysicalNetBIOS') , [ServerName] = SERVERPROPERTY('ServerName') , [IP Address Of SQL Server] = LOCAL_NET_ADDRESS , [IP Address Of Client] = CLIENT_NET_ADDRESS FROM SYS.DM_EXEC_CONNECTIONS WHERE SESSION_ID = @@SPID
The IP Address of SQL Server is 172.30.0.95
SELECT net_transport = CONNECTIONPROPERTY('net_transport') , protocol_type = CONNECTIONPROPERTY('protocol_type') , auth_scheme = CONNECTIONPROPERTY('auth_scheme') , local_net_address = CONNECTIONPROPERTY('local_net_address') , local_tcp_port = CONNECTIONPROPERTY('local_tcp_port') , client_net_address = CONNECTIONPROPERTY('client_net_address')
The IP Address of SQL Server is again noted as 172.30.0.95.
Attempt DB Server Access using Server’s IP Address
If you try to access the DB Server using the IP Address 172.30.0.95, you will not be able to.
Is your DB Server IP Address private?
Go to http://mxtoolbox.com/ReverseLookup.aspx and determine if our address is private
Is a private IP address…
It is important to either mark the DB Server as publicly available or to properly configure the VPC to properly route traffic behind the scene to the DB Server’s private IP Address.