The Farrellel Universe

It's not a lot, but a small piece of code I submitted to the DotNetNuke project was accepted today and included in the next release.

I had almost totally forgotten I'd submitted it, but it was included yesterday.

We must celebrate the minor victories :).

When deploying multiple instances of DotNetNuke, depending on the environment you are working in, you may encounter an error like the following:

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The entry 'SiteSqlServer' has already been added.

Source Error:

Line 21: <connectionStrings>
Line 22: <!-- Connection String for SQL Server 2005 Express -->
Line 23: <add name="SiteSqlServer" connectionString="Data Source=.\SQLExpress;AttachDbFilename=|DataDirectory|Database.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />
Line 24: <!-- Connection String for SQL Server 2000/2005
Line 25: <add

This has to do with IIS carrying over connection string keys from other application instances.

A simple remedy is to add the following directive at the beginning of the <connectionString> directive in your web.config file.

<remove name="SiteSqlServer" />

This will remove the offending key before it generates an error.