Connecting MS SQL Management Studio to AWD RDS
Posted on 2014-11-04
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)
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!