How to "Add Databse Server" and "Add Database Connection"

Discussion created by kyle.souza on Mar 25, 2013
Latest reply on Jul 22, 2013 by kpeter-esristaff

     I will admit, I am a bit green when it comes to ArcGIS for Server and ArcSDE, but I have gone through all the documentation I could find, and blogs from non-Esri sources, and cannot find an answer for 10.1 that works, and it may be that I am missing a step along the way.

What I need: 
To be able to add the ArcServer/SDE instance from AWS to ArcGIS for Desktop on my local machine via "Add Databse Server" and/or "Add Database Connection".

What I have:
ArcGIS Server 10.1 and ArcSDE (SQL Server) on Amazon Web Services
I am able to connect to to the ArcGIS Server via the "Add ArcGIS Server" method.

What I have tried:
Everything I could think of.
I can connect to the SDE fine on the AWS machine.
Add Database Server - I tried <IP address>\MSSQLSERVER and <IP address>\sqlexpress
Add Database Connection -  Platform - SQL Server
Add Database - Instance - I have tried variations of the server url and the ip address and the dynamic dns
Add Database - Authentication - I've tried to, but I think i need to use "database" and have entered the Administrator info here.
I never get a list of databases (should be EGDB and geodata).

Any help would be greatly appreciated!