My site is not able to establish a connection to the SQL Server 2012 from EC2. My connection string is as follows:
Data Source=AMAZONA-2SSRDM3;Initial Catalog=MyDatabase;Integrated Security=SSPI;
As you can see I am using Windows Authentication; is there something wrong with this approach I am taking? I am new to Ec2
The New Connection string i am using is
connectionString="Data Source=http://ec2-46-137-228-121.ap-southeast-1.compute.amazonaws.com/;Initial Catalog=MyDb;User ID=something;Password=something"
More Info : I just restored a new database on to my Ec2 Machine . My sql server instance was using only Windows Authentication which i changed to Mixed Mode. I created a new Login something and made it the Db Owner of the Restored Database as well