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 Antworten
0
Akzeptierte Antwort

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
EXPERTE
beantwortet vor einem Jahr
EXPERTE
überprüft vor einem Jahr
  • 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
beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen