Windows Server Enterprise 2003 with SP1, ASP.NET 2.0, SQL Server 2005, IIS 6.0

1. I created SQL 2005 databases (not SQL Express) with proper uid and pwd in web.config.

2. I created virtual directory pointing at unzipped install folder with all permissions possible

3. Browse to http://localhost/DNN3. Install completed successfully.

4. Login as host, go to Module Definitions, at bottom of the page, I see this error message:

Unhandled error loading module.
DotNetNuke.Services.Exceptions.ModuleLoadException: Unhandled Error Adding Module to ContentPane ---> System.InvalidOperationException: The stored procedure 'dbo.GetModuleByDefinition' doesn't exist. at System.Data.SqlClient.SqlCommand.DeriveParameters() at System.Data.SqlClient.SqlCommandBuilder.DeriveParameters(SqlCommand command) at Microsoft.ApplicationBlocks.Data.SqlHelperParameterCache.DiscoverSpParameterSet(SqlConnection connection, String spName, Boolean includeReturnValueParameter, Object[] parameterValues) at

I tried version 3.2.2 and 4.0.2, the same error message showed up.

I check both of my databases, there are stored procedures called:

GetModuleDefinition, GetModuleDefinitionByName, GetModuleDefinitions

But NO GetModuleByDefinition exists.

What's wrong?

Unfortunatly, I get the same error.

The first problem was the install itself. After reading a hint in this forum, I changed the Case-Sensitive database (default on this SQL Server 2005 is "Latin1_General_CS_AS") into an Case-InSensitive one ("SQL_Latin1_General_CP1_CI_AS"). After this change the install run successful for both Versions 3.2.2 and 4.0.2.

But now, I have the same problem as you described: 'dbo.dnn322_GetModuleByDefinition' for the 3.2.2 installation and 'dbo.dnn402_GetModuleByDefinition' for the 4.0.2 installation. (I definied the "objectQualifier" in the web.config, but they run in 2 separated databases). This happens when I am trying to insert a module into a page.

Then I tried to view the log, but instead of the log this errormessage appears:

Error: Log Viewer is currently unavailable.
DotNetNuke.Services.Exceptions.ModuleLoadException: Ein Sortierungskonflikt zwischen "Latin1_General_CS_AS" und "SQL_Latin1_General_CP1_CI_AS" im equal to-Vorgang kann nicht aufgelöst werden. ---> System.Data.SqlClient.SqlException: Ein Sortierungskonflikt zwischen "Latin1_General_CS_AS" und "SQL_Latin1_General_CP1_CI_AS" im equal to-Vorgang kann nicht aufgelöst werden. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) 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() at DotNetNuke.Modules.Admin.Log.LogViewer.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

Aha ... something is still not working well here! But ... how to solve this? 

The Websites run on a Windows 2003 Server with IIS 6 and SP1 & SQL Server 2005.

Does anybody have some suggestions ... without reinstalling the whole SQL-Server-2005?

TIA!

Mark