Hello, I Hope I am in the right place..

DNN 04 .08.04   -   SQL  DataProvider   

I have a problem, I get the error below when using the event viewer from the Admin Menu.

The site seems to be working fine although I do not seem to be able to install the revised documents module without getting a similar Collation Conflict error.

I have checked with the Company Hosting the site who say "We can't resolve the collation conflict as elements of the database rely on it being Latin1_General_CI_AI. The culture of our servers should all be en-GB."

I am assuming therefore that the database I have  is SQL_Latin1_General_CP1_CI_AS, or is it just one table?

I checked the web config globalization and it was en-US  have changed that to en-GB,

My problem now is a puzzle first, and terror second...  Puzzle...  why only the event log showing the problem and why has it occurred- I never used the event log until the last few days so cannot say how long the issue has existed,  I have done no upgrades or anything since DNN was installed.

Terror..  What can I do about it?  the site is built , tested , loaded with data and due to go live imminently,  the thought of having to re-enter all the data is a horror to contemplate and whilst reading would suggest I could use the sql database publishing wizard to script the DB to file, and the create a new db with the correct collation and then run the script against it, change the database the site uses to the new one...etc. I am not sure my SQL skills are up to it.

In the hope you might offer some more ready and simple explanation ( and of course solution...) I eagerly await some response.

Error Message below... returned when choosing event viewer from Admin Menu

:

::  DotNetNuke.Services.Exceptions.ModuleLoadException: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. ---> System.Data.SqlClient.SqlException: Cannot resolve the collation conflict between "Latin1_General_CI_AI" 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 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(SqlConnection connection, SqlTransaction transaction, CommandType commandType, String commandText, SqlParameter[] commandParameters, SqlConnectionOwnership connectionOwnership) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.Data.SqlDataProvider.GetLog(Int32 PageSize, Int32 PageIndex) at DotNetNuke.Services.Log.EventLog.DBLoggingProvider.DBLoggingProvider.GetLog(Int32 PageSize, Int32 PageIndex, Int32& TotalRecords) at DotNetNuke.Services.Log.EventLog.LogController.GetLog(Int32 PageSize, Int32 PageIndex, Int32& TotalRecords) at DotNetNuke.Modules.Admin.Log.LogViewer.BindData() in C:\Inetpub\vhosts\dccare.hostinguk.org\httpdocs\www\Admin\Logging\LogViewer.ascx.vb:line 110 at DotNetNuke.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) in C:\Inetpub\vhosts\dccare.hostinguk.org\httpdocs\www\Admin\Logging\LogViewer.ascx.vb:line 411 --- End of inner exception stack trace ---