Release external access on sql server 2014

Question

Release external access on sql server 2014

Navigation

#1 by (3 votes)

3

I have a machine in amazon, and the sql server is installed but I can not access from outside the server. I would like to know if there is any configuration other than to release the protocol in the Security group.

sql-server ec2

asked by anonymous 11.08.2014 / 18:31

1 answer

List all months in an interval, or query or schedule? How to make jQuery .load only load content inside the main?

score 3 · Answer 1

The most common error is to mount the wrong connection string.

Are you just adding the ENDPOINT port in the connection string?

You need to copy the name of ENDPOINT (something like sqlsvr-pdz.c6c8mdfntzgv0.us-west-2.rds.amazonaws.com) and then put a ',' and the ENDPOINT connection port, at the end the string should look something like this:

sqlsvr-pdz.c6c8mdfntzgv0.us-west-2.rds.amazonaws.com,1433

The ENDPOINT and the connection port you get in the Management Console screen, in the server description, you have these two information.

Also remember that the username and password to be used in MSSQL Management Studio is the user and password of the SQL master user, not your AWS account.