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