I have the same problem:

Source Error:

[NullReferenceException: Object reference not set to an instance of an object.]
   DotNetNuke.Entities.Portals.PortalSettings.GetSiteSetting(Int32 PortalId, String SettingName) +36
   DotNetNuke.HttpModules.UrlRewriteModule.OnBeginRequest(Object s, EventArgs e) +2968
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

I only restore the database on hosting provider, and i run the application locally, connected to this remote database, and this error appear. What can i do?

The problem was that the DTS wizard is not compatible with the way that DNN defined their ids on database. When you upload data with DTS after run the scripting for create database, the ids on tables are creating again.

So first, upload the data with DTS, and then run the scripting for create a database. Some ids and relations dosen't be create, but the application run anyway.

DNN team.. please use uniqueidentifier(guid) in your databases ids :).

Best regards.

Yes, you have rigth. But the principal problem today for the dnn developers, it is that the hosting providers dosen´t provides the posibility of backup and restore databases (it´s a permissions problem) ... so, with DTS you can´t create an exactly copy of your dnn database.

Thanks!!
Best regards.