Hi folks,

I've recently backed up my DNN 4.3.0 and the database from site and now I'm taking the files and doing a restore operation on a second server.

What I've done:

Unzipped DNN backup that was created with Grupolite in to the web root.

Restored database using restore filelistonly from disk ...

Restored files using restore database desd from disk ...

Set permissions for Network Services to full control for its web root

Created the appropriate user in the database for connectivity.

In web.config pointed the two database connectivity lines to localhost database server via 127.0.0.1 (later changed to the actual IP of the machine)

Changed the PortalAlias to the propper domain name.

Set debug to true (nothing extra seems to happen)

Set the database's collation to Latin1_General_CI_AS (Collation was originally set to SQL_...CI_AS or something similar)

I've looked in various logs but they aren't getting updated, I've set the system to audit the directories to see if there's a permission issue on them but there doesn't appear to be any. Checked the actual web logs, there doesn't appear to be any errors occuring in them.

What can I do to correct the error being received?

Thanks in advance.

The following error is occuring when I log in and load up the site:

DotNetNuke.Services.Exceptions.ModuleLoadException: Must declare the scalar variable "@ModuleID". ---> System.Data.SqlClient.SqlException: Must declare the scalar variable "@ModuleID". 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.Modules.Announcements.SqlDataProvider.GetAnnouncements(Int32 ModuleId) at DotNetNuke.Modules.Announcements.AnnouncementsController.GetAnnouncements(Int32 ModuleId) at DotNetNuke.Modules.Announcements.Announcements.Page_Load(Object sender, EventArgs e) --- End of inner exception stack trace ---

I have been getting same error when I tried to add/configure some module such as forum, events,etc.. Please help, I am stuck. I did same thing with the originator of the issue which was backed up the database in my local PC and restored on the hosting server and has some may issues like this 'error occured', 'module is unavailable', blah, blah

Thanks in advance.