Troubleshooting Checklist: Migration

Information

The following is a troubleshooting checklist that should be referenced when facing issues with a DNN instance migration. 

 

IIS Settings

  • The site in IIS is pointing to the root folder that you expect.
  • Check the application pool that the site is using.
  • Check the identity that the application pool is using.
  • Check which binding(s) are added to the IIS site.
    • Update host file if no DNS record is present for the binding.
  • Add self-signed certificate if SSL is needed.

Windows Explorer

  • The identity has Modify permission on the root folder.
  • The connection string in the web.config has the correct server, database, and user.

Database

  • The user exists in SQL server and has db_owner permission on the database.
  • The binding host is added as a portal alias in the database.
    UPDATE PortalAlias
    SET    HTTPAlias= 'sitename.dnndev.me' 
    WHERE  PortalAliasID = 1
  • DefaultPortalAlias portal setting updated:
    UPDATE PortalSettings 
    SET    SettingValue = 'sitename.dnndev.me' 
    WHERE  PortalID = 0 
           AND SettingName = 'DefaultPortalAlias'; 
  • Empty DNNPro_License and WebServers tables:
    DELETE FROM DNNPRO_License; 

    DELETE FROM WebServers; 
  • Disable SSL Settings if not using a certificate in IIS:
    UPDATE PortalSettings 
    SET    SettingValue = 'False' 
    WHERE  SettingName = 'SSLEnabled'; 
  • Set SMTP server to localhost:
    UPDATE HostSettings 
    SET    SettingValue = '127.0.0.1' 
    WHERE  SettingName = 'SMTPServer'; 
    UPDATE HostSettings 
    SET    SettingValue = '' 
    WHERE  SettingName = 'SMTPUsername'; 
    UPDATE HostSettings 
    SET    SettingValue = '' 
    WHERE  SettingName = 'SMTPPassword'; 
    UPDATE HostSettings 
    SET    SettingValue = 'N' 
    WHERE  SettingName = 'SMTPEnableSSL';

AD Authentication

  • The server must be part of the domain.
  • Windows Authentication installed as a feature.
  • BackConnectionHostNames registry setting added if using a local URL.
  • Binding added to Trusted and Intranet sites in IE options.

DNN API and Microservices

  • Execute this query:

    UPDATE HostSettings 
    SET    SettingValue = 'False' 
    WHERE  SettingName IN ('AnalyticsEnabled', 'FormBuilderEnabled', 
                            'StructuredContentEnabled') 

    GO 

    UPDATE PortalSettings 
    SET    SettingValue = 'False' 
    WHERE  SettingName IN ('AnalyticsEnabled', 'FormBuilderEnabled', 
                            'StructuredContentEnabled') 

    GO 

    DELETE PortalSettings 
    WHERE  SettingName IN ('AnalyticsAccountCode', 'AnalyticsClientCredentials', 
                                                  'FormBuilderClientCredentials', 
                            'StructuredContentClientCredentials') 

    GO 
  • Delete the file ~/Portals/_default/Licenses/Microservices.resources.
  • Recycle the Application pool.
  • Clear the browser's cache.
  • Re-enable Analytics/Content/Forms as needed.

 

Back to top

Comments

0 comments

Please sign in to leave a comment.