RDS AMAZON - Difficulties connecting to the Database

1

I created a Sql server instance in Amazon, but I can not connect through the Sql Server Management Studio.

I get the message:

  

error 10060
  Can not connect to endpoint address, 1433.

I'm using the following data:

Server name the address of endpoint, 1433 . Login and password entered in the% Master field Username and password when creating the instance.

I really do not know, what needs to be done. Would anyone know?

    
asked by anonymous 10.09.2015 / 12:45

1 answer

0

This page explains everything. To connect from your PC to your instance in RDS, you need to know:

  • The endpoint of the instance, something like: meu-rds-sql-server.abcdefgh123.us-east-1.rds.amazonaws.com
  • The port of the endpoint. The default is 1433 but it is good to confirm in the properties of your RDS instance.
  • The login / password
  • Your Public IP

To access your DB from outside AWS you need to enable public access (or use VPC.) But you also can not just leave your DB so exposed to the entire internet. So it's good to put a Security Group that only allows Inbound access from your IP address.

Inspect the properties of your instance in the RDS AWS Console. There is the endpoint, port, login, etc. In particular, inspect the Security Groups associated with your instance. Modify or add a Security Group to allow only your IP to access your instance.

With all this set you should be able to access your DB from your PC.

    
16.09.2015 / 20:50