Overview

This article aims to provide guidance on how to change the host email address that is sent from the DNN Notification and Emails to DNN users. If you have set up SMTP, users will begin to start receiving emails whenever a certain action has been completed such as page publishing, account creation or role changes.

Prerequisites

• DNN version 9.3 and below as the ability to change this setting has been added in Settings > Servers > Server Settings > SMTP Server.

Diagnosis

The host email is the "from" address of DNN notification emails. It is based on the email that was entered when the DNN environment was first set up. Since there is no UI available to change this setting after it has been set, you can change this through a simple SQL query. To verify the current setting for the Host email, you can follow the steps below:

1. Navigate to Persona Bar > SQL Console. (For versions before 9.x, go to Host > SQL Console.)
2. Execute the following query: SELECT * FROM HostSettings WHERE SettingName = 'HostEmail'
   
   

Solution

To change the email address to which the SMTP and Form Builder notifications are sent, please follow the steps below:

1. Back up the database.
    
   
   1. Click Start.
   2. Type SSMS and press Enter to open the SQL Server Management Studio.
   3. In the Connect to Server window, in the Server name field, enter your SQL server's name.
   4. Click Connect.
   5. Expand the Databases.
   6. Right-click on the database name.
   7. Select Tasks > Back up.
   8. Click OK.
       
2. Navigate to Persona Bar > SQL Console. (For versions before 9.x, go to Host > SQL Console.)
3. Run the following SQL query to change the email address. Replace the [email address] with your preferred email address.
    
   

   SELECT * 
   FROM   hostsettings 
   WHERE  settingname = 'HostEmail' 
   
   UPDATE hostsettings 
   SET    settingvalue = '[email address]' 
   WHERE  settingname = 'HostEmail' 

    
4. Go to Persona Bar > Settings > Servers. (For versions before 9.x, go to Tools.)
5. Clear the cache.
6. Restart the application.
    
   Warning! The site will be unavailable while the application restarts. The downtime may take up to 5 minutes.

Back to top

Testing

To test this solution, log into any Content Editor user or higher and try publishing a page under a workflow with more than one state. You should be able to receive an email on another administrator account that a page has been published or waiting for review.

Back to top