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
전문가
답변함 일 년 전
전문가
검토됨 일 년 전
  • 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
답변함 일 년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠