SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Problem Connecting to an AWS SQL 2012 Standard Server Instance using 2012 SQL Express instance


Problem Connecting to an AWS SQL 2012 Standard Server Instance using 2012 SQL Express instance

Author
Message
dflaherty
dflaherty
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 15
Hello all.

I am a SQL newbie, and I am having trouble connecting to a AWS SQL Server 2012 Standard instance I set up a couple of days ago. I can connect fine on my computer at work (an Apple Mac running parallels, SQL version 2012 standard), but from home I am having problems connecting the AWS instance. I am getting error 53, and my computer at home is an Apple, running parallels, SQL Server 2012 Express.

I have tried to change my IP/TCP settings (enabled) through SQL configuration manager, setting up port 1433, but no luck. I am not sure what the settings should be, and how to ping the AWS server instance. This is very frustrating because I want to continue testing and learning how to use SQl with my company's data at night but I can't login.

Any help would be appreciated, I just can't figure this out.

dflaherty
HowardW
HowardW
SSCrazy
SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)SSCrazy (2.3K reputation)

Group: General Forum Members
Points: 2251 Visits: 9892
AWS meaning Amazon Web Services? In an EC2 instance, or through Amazon RDS?

Are you connecting to your work network via VPN, or trying to access directly via the internet?

By default you're prompted to setup inbound IP restrictions when setting up resources in Amazon (you wouldn't want your SQL Instance directly exposed to the big bad web), so it's probably that your home IP address isn't allowed access, but your work IP address is.

I doubt you'd really want to be adding people's home (dynamic) IP addresses into the AWS firewall configs, so you would need to hop via your corporate network, either via VPN, with the correct config so the AWS address is routed via your corporate external IP, or another secure access method, e.g. Citrix/RDP to a computer on the corporate network with SSMS installed.

You can use telnet to check whether the basic network access is there, e.g. from a cmd/shell prompt "telnet <aws URL> 1433"
dflaherty
dflaherty
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 15
I got it figured out, I just needed some more time to understand how AWS sets up it's instances and the security groups.

Thank you for your time!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search