I've got 4.08 installed and working and all the modules that don't touch the SQL database seem to work fine (News, Announcements, HTML, etc.) but any module that uses SQL data (Users Online, FAQs, Repository) errors out:

DotNetNuke.Services.Exceptions.ModuleLoadException: 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.

The thing is that I know it's reaching SQL because I can log in OK but it still won't display any other data. Anyone seen this before?

Here's the pertinent part of web.config. The format is a little different but that's the way it was in the original file. Should I make them exactly the same?

...

<connectionStrings>

<!--
Connection String for SQL Server 2005 Express

<add name="SiteSqlServer"
connectionString="Data Source=.\SQLExpress;Integrated Security=True;User Instance=True;AttachDBFilename=|DataDirectory|Database.mdf;"
providerName="System.Data.SqlClient" />
-->

<!--
Connection String for SQL Server 2000/2005
-->

<add name="SiteSqlServer" connectionString="Data Source=______;Initial Catalog=_____;User ID=_____;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="SiteSqlServer" value="Server=_____;Database=_____;uid=_____;pwd=_____;" />

<add key="InstallTemplate" value="DotNetNuke.install.config"/>

<add key="AutoUpgrade" value="false"/>

....

one of them is for DNN 4 core and DNN 4 modules, the other is legacy support for DNN 3 modules.