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 réponses
0
Réponse acceptée

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
répondu il y a un an
EXPERT
vérifié il y a un an
  • 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
MODÉRATEUR
philaws
répondu il y a un an

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions