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="data source=SFP\SFP_SQL_SVR;attachdbfilename=C:\Users\Mark\Documents\Databases\Shoes.mdf;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" 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';