I have used Microsoft Webmatrix 3 to deploy a small DNN 7 website to a remote hosting service server.

Webmatrix confirms that the deployment of both the website and database are OK. i.e. both are clearly accessible using the remote configuration details provided to Webmatrix.

On trying to access the website on the remote server I get an error that seems to indicate a probable problem with the SQL Server connection strings in web.config. I have seen elsewhere that two strings need to be set appropriately for the website to work. I have tried various ways to get the appSettings string to match the connectionStrings entry, but I can't seem to get it to work.

My current web.config section is listed below and I would appreciate it if someone could tell me exactly how to correct the appSettings section.

<connectionStrings>

<!-- Connection String for SQL Server 2008/2012 Express -->

<add name="SiteSqlServer" connectionString="Data Source="10.127.255.4\SQL2014, 780";Initial Catalog=shanedhorloc_wlhg;User ID=shanedhorloc_host;Password=MNBVC1!xz" providerName="System.Data.SqlClient" />

<!-- Connection String for SQL Server 2008/2012

<add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=;pwd=;" providerName="System.Data.SqlClient" />

-->

</connectionStrings>

<appSettings>

<!-- Connection String for SQL Server 2008/2012 Express - kept for backwards compatability - legacy modules -->

<add key="SiteSqlServer" value="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" />

<!-- Connection String for SQL Server 2008/2012 - kept for backwards compatability - legacy modules

<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=;pwd=;"/>