Hi,
We upgraded to 4.5.3 a few weeks ago. For the most part, all seemed to be working fine (the few sites we upgraded were very simple sites). But today I noticed that when adding certain new modules (i.e. it happens for the repository module, but not for the text/html module) to a site, I am getting an error that shows up inside the page:
A critical error has occurred.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
After doing some research, my hunch is that this has to do with our web.config file - specifically, the connection strings. When I looked at it, I realized that we seem to have a connection to BOTH SQL Server 2005 and SQL Express. When I try to comment out the SQL Express connection string and bring in the SQL Server string, ALL sites completely crash. Below is the relevant section of our web.config file:
<
<!--
<add
name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
connectionStrings> Connection String for SQL Server 2005 Express
-->
<!--
<
</
<
<!--
<
<!--
<add key="SiteSqlServer" value="Server=(local);Database=DotNetNuke;uid=USERID;pwd=PASSWORD;"/>
<
Connection String for SQL Server 2000/2005 -->add name="SiteSqlServer" connectionString="Server=(local);Database=DotNetNuke;uid=USERID;pwd=PASSWORD;" providerName="System.Data.SqlClient" />connectionStrings>appSettings> Connection String for SQL Server 2005 Express - kept for backwards compatability - legacy modules -->add key="SiteSqlServer" value="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;" /> Connection String for SQL Server 2000/2005 - kept for backwards compatability - legacy modules-->add key="InstallTemplate" value="DotNetNuke.install.config" />
Any thoughts?