Connection String for ASP.NET Hosting on Online Server

I have an ASP.NET C# application with a SQL server 2012 database that has consolidated membership provider and application database. I am trying to modify my web config according to the instructions provided by the hostforlife.eu hosting service but I think I'm missing something.

Here is my current web.config connection strings:

<connectionStrings>
<add name="ShoesDB" connectionString="data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Mark\Documents\Databases\Shoes.mdf;Integrated Security=SSPI;"/>

<add name="ShoesEntities" connectionString="metadata=res://*/Shoes.csdl|res://*/Shoes.ssdl|res://*/Shoes.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Mark\Documents\Databases\Shoes.mdf;integrated security=True;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

</connectionStrings>

Here is the connection string that the web hosting service has given me:

Data Source=Shoes.db.hostforlife.eu; Initial Catalog=shoes; User ID=your username; Password='your password';

0 answers