title: SQL Server Database Connection in VS 2010
body: <p>I have completed my program in MVC in VS 2010. In the connection string I have the following</p>
  
  <pre><code>&lt;add name="RacePaceDBContext" 
       connectionString="data source=XX.XXX.XX.XXX,1433;Initial Catalog=RacePaceDataNew;Persist Security Info=True;User ID=user;Password=password;MultipleActiveResultSets=True" 
       providerName="System.Data.SqlClient"/&gt;
  </code></pre>
  
  <p>Which connects to a SQL Server running on an EC2 instance on Amazon AWS.</p>
  
  <p>The program runs fine and the connection works great. The program connects and creates/reads data etc.</p>
  
  <p>However, I am not sure why when I try "Connect To Database" in the server explorer on the left, and fill in the same settings it just doesn't connect. Any ideas why this would be different? As want to be able to log in and see my tables, data etc without having to log onto AWS. The same is true when I use MySQL Workbench to try connect - it gives me an error telling me the server isn't accessible.</p>