3
I have a machine on Amazon, and sql server is installed but I can’t access from outside the server. I wonder if there are any settings besides releasing the protocol in Security group.
1 answer
3
The most common error is mounting the wrong connection string.
You happen to be adding the ENDPOINT port to the connection string?
You need to copy the ENDPOINT name (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 on the screen of Management Consoles, in the server description, you have these two information.
Also remembering that the user and password to be used in MSSQL Management Studio is the SQL master user and password, not your AWS account.
Browser other questions tagged sql-server ec2
You are not signed in. Login or sign up in order to post.