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 個答案
0
已接受的答案

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
專家
已回答 1 年前
專家
已審閱 1 年前
  • 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
管理員
philaws
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南