January 10, 2011 at 3:56 pm
I've set the database on the cloud to accept remote connections.
I've got a login that works in that database.
I've got a the firewall database port open.
After that I'm completely lost on how to connect to the cloud database from my local SSMS instance.
Is it even possible?
Can I connect using a new connection or do I need to make it a linked server or something?
Help!
ps: Not finding much helpful on the internet.
January 12, 2011 at 11:32 am
*bump*
Does anyone have a SQL Server 2008 Management studio connection to an Amazon cloud database? If so, how did you do it?
January 12, 2011 at 1:42 pm
Nevermind, I figured it out.
Needed to use the IP address or the DNS string rather than the actual server name.
Donalith
January 12, 2011 at 2:06 pm
Thanks for the note.
I edited this to reflect SSMS, which is what I think you mean. It's Management Studio. Note that this isn't an instance. SSMS on your machine does not imply the SQL Server is on your machine, nor is your local SQL Server instance connecting to Amazon. It's SSMS, which is the same as if you used Excel and an OLEDB connection.
The IP makes sense as it was likely some networking/name resolution issue.
January 12, 2011 at 4:00 pm
Thank you for the note!
I'll try to be more specific in the future!
Donalith
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply