Connecting MS SQL Management Studio to AWD RDS

I am starting a new account with Amazon AWS using their RDS SQL Server Web Edition database.

I have spent countless hours trying to connect to the database via SQL Server Management Studio.

Apparently, my RDS is in VPC for security, but I have followed all the steps one by one multiple times.  I keep getting the error...

A network-related or instance specific error occurred while establishing a connection to SQL SERver....error: 25 - Connection string is not valid (MS SQL Server Error: 87)

The documentation is unclear whether I should be trying to connect using the end-point DB string which is:  (altered)

     mydbname.cpudpe24czkm.us-east-1.rds.amazonaws.com:1433

Or, because it is in a VPC, someone should I point o that, I read a bit that said I need to assign an IP to the VPC, but I don't see how that can happen.

Thanks for any help, this has been driving me crazy!
LVL 39
gdemariaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lcohanDatabase AnalystCommented:
"Benefits of Using a VPC
[...]
                  • Assign static private IP addresses to your instances that persist across starts and stops
[...]
"

Do you have that IP? If yes the connection string must include it after you build it via AWS and BTW "I have spent countless hours trying to connect to the database via SQL Server Management Studio.
" - did you already created your database as per link below?


http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_GettingStarted.CreatingConnecting.SQLServer.html
0
gdemariaAuthor Commented:
> Do you have that IP?
This is a point of confusion.  I have two elastic IP addresses pointing to two startup web servers.  When I attempt to associate an IP with a network, I get confused.  First, it shows three options (where image show eni-xxxx number, there are three choices) I don't know what any of them refer to.  Also, when I choose one, it seems to break my elastic IPs that are pointing to my web servers.  Not sure why assigning a 3rd Elastic IP would break the other two.   Am I doing this right?

Associate Elastic IP Address to Network

What is supposed to be the valid path for me to put into SQL Server management studio to access it from my PC over the internet?   Do you have an example.
0
Dexter NaagAWS Specialist / System & Network AdminCommented:
First you need to look for your own public ip address by going to ipchicken.com and remember your public ip address.

Go to your RDS AWS Console, then Security Groups and Default. On the 'Connection Type' below choose CIDR/IP and put your public ip address on the CIDR/IP to autorize box.

Ensure that you have /32 on the last part of your public ip address. Click the blue Authorize box

Wait until the status shows 'authorized'  then test your SQL Server Management studio again using the Endpoint
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Cloud Computing

From novice to tech pro — start learning today.