Private IP of MSSQL RDS Instance

0

We have made a new RDS Database and we have a public DNS record of it to connect. How can I find its private IP to connect from within the AWS network in same zone.

2 Answers
0
Accepted Answer

Hi,

This should help you finding out the private IP address of an rds db.

https://aws.amazon.com/premiumsupport/knowledge-center/rds-ip-address-issues/

If helps, I d appreciate if answer is accepted :) Thanks!

profile picture
EXPERT
answered a year ago
EXPERT
reviewed a year ago
  • In particular note that the IP address is dynamic and will change, so you should use the endpoint DNS name assigned by AWS. You say "we have a public DNS record" so I guess you're wanting to point a custom DNS name to that endpoint? You can, but note RDS doesn't support adding your custom domains to a DB's SSL certificate, so any client using the custom domains has to cope with host name identity verification failing if enabled.

  • Thanks, the link provided clarifies that it would connect to the public interface if connected from Outside AWS network and to Private Interface if connected from within the AWS Network

0

You can just call nslookup on the endpoint for your instance:

$  aws rds describe-db-instances --db-instance-identifier your-database --region us-west-2 --query "DBInstances[*].[Endpoint.Address]"
[
    [
        "your-database.us-west-2.rds.amazonaws.com"
    ]
]

$ nslookup "your-database.us-west-2.rds.amazonaws.com"
Server:         10.1.0.2
Address:        10.1.0.2#53

Non-authoritative answer:
Name:   your-database.us-west-2.rds.amazonaws.com
Address: 10.1.149.12
AWS
MODERATOR
philaws
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions