RDS AMAZON - Difficulties to connect in Database

Asked

Viewed 1,654 times

1

I created a database instance Sql server on Amazon, however I cannot connect to Sql Server Management Studio.

I get the message:

error 10060
Unable to connect to endpoint address,1433.

I am 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 don’t know what needs to be done. Someone would know?

sql-server aws rds
  • 1

    Have you checked if your IP address is in the security group? I believe that Amazon already puts the IP you were using in this group at the time of creating the bank. If you have purchased another IP you will have to go there and add.

  • my network ip?

1 answer

0


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

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

To access your DB from outside of AWS you need to enable public access (or use VPC.) Only you also can’t just leave your DB like this, exposed to the whole internet. So it’s good to put a Security Group that only allows access Inbound from your IP address.

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

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

  • I did all this and could not connect. - I set endpoint, port, login/password. - I created inbound for security group with my public ip. And nothing!

Browser other questions tagged sql-server aws rds

You are not signed in. Login or sign up in order to post.