The Scenario
I have written a Silverlight 3 Application that uses an SQL Server database. I'm moving the application onto the Cloud (Azure Platform). In order to do this I have had to setup my database on SQL Azure. I am using the ADO.Net Entity Framework to model my database. I have got the application running on the cloud, but I cannot get it to connect to the database. Below is the original localhost
connection string, followed by the SQL Azure
connection string that isn't working. The application itself runs fine, but fails when trying to retrieve data.
The Original Localhost
Connection String
<add name="InmZenEntities"
connectionString="metadata=res://*/InmZenModel.csdl|res://*/InmZenModel.ssdl|res://*/InmZenModel.msl;
provider=System.Data.SqlClient;
provider
connection string="
Data Source=localhost;
Initial Catalog=InmarsatZenith;
Integrated Security=True;
MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
The Converted SQL Azure
Connection String
<add name="InmZenEntities" connectionString="metadata=res://*/InmZenModel.csdl|res://*/InmZenModel.ssdl|res://*/InmZenModel.msl;
provider=System.Data.SqlClient;
provider
connection string="
Server=tcp:MYSERVER.ctp.database.windows.net;
Database=InmarsatZenith;
UserID=MYUSERID;Password=MYPASSWORD;
Trusted_Connection=False;
MultipleActiveResultSets=True""
providerName="System.Data.EntityClient" />
The Question
Anyone know if this
connection string for SQL Azure is correct?
Help greatly appreciated.
