Has anyone ever managed to connect to Microsoft SQL Server (preferably 2008) hosted on Amazon EC2 from Management Studio on your development machine?
I have set up the security group to allow port 1433, opened port 1433 outbound from Windows Firewall to no avail.
Error from Management Studio is '26 - Error Locating Server/Instance Specified'. I am using the associated Elastic IP address as the server name.
Tried searching 'sql-server ec2', but no similar problem found.
The server is accessible from local EC2 Management Studio.