Hi,

After a HD crash at my web host my DNN-installation was moved from SQL2000 to SQL2005 which caused some problems because the language settings were different between those two servers. One thing was that the System Log stopped working, just produces an error message like

DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot resolve the collation conflict between "Finnish_Swedish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. ---> System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Finnish_Swedish_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at (...)

Another thing was that newly registred members did not get the proper roles, or rather they got their roles but DNN was unable to recognize those when entering a page that needed a certain role.

After switching the language back new-new registrations are now working fine, the users registred in the days that the language settings were wrong will have to re-register but that is ok.

BUT the System log still produce the above error message, although it should not.

Is there a way to clear the System log so that it can start from fresh?

/S

Should the checkbox for "Run as script" be checked?