You should perform this upgrade at a time when you are not delivering a newsletter.  If a newsletter is currently being delivered wait until the send has completed.  It is recommended you wait until 48 hours after any newsletter has been sent and then perform the upgrade.  Click here to see what's new in this update.    Note: This upgrade works only with version 2.5.  If you are not using 2.5 please contact us.  The version is listed at the bottom of the administration console.

Please verify that your server meets the following requirements for eNewsletter Pro version 7 for .NET:

• .NET Framework 2.0 (Note: this can be installed using the Windows Update tool)
• Make sure the IIS Application for eNewsletter Pro has selected .NET 2.0 on the ASP.NET Tab.  If 1.1 is selected and you change to 2.0 make sure this application pool is not shared by other applications running .net 1.1 or you will get an error.
  

1. Make a backup copy of your database as this upgrade will modify the database.  
   
2. Unzip the contents of eNewsletterProEnterprise7UpgradeFrom25.zip in a temporary location somewhere on the server where eNewsletter Pro is installed.  You will now see the following folders:
   
   eNewsletterPro
   Database
   MailEngine
   
3. Obtain the following database connection properties found in db.asp which is located in the web folder currently holding eNewsletter Pro:
   
   Database Name
   Database User Name
   Database Password
   Data Source (IP or Server Name)
   
4. Set the database connection in the web.config file located in the eNewsletterPro folder.  The variable is called DBConnectionString.
   
   <add key="DBConnectionString" value="server=XXX.XXX.XXX.XXX;UID=eNewsletterPro;PWD=yourpassword;DATABASE=eNewsletterPro" />
   
   Server=The IP Address of the SQL server
   UID=The Username you assigned to the database.  The default username is eNewsletterPro
   PWD=The password you assigned to the database
   DATABASE=The name of the database.  The default is eNewsletterPro
   
5. Make sure the web folder holding eNewsletterPro is an application starting point.  If eNewsletterPro is installed in its own web site, then you need not worry about this.  Otherwise, please follow these instructions to make the folder an application starting point.
   
6. Next, Execute the SQL script called enewsletterpro7UpgradeFrom25.sql on your existing eNewsletter Pro Enterprise database.  The script is found in the folder where you unzipped the files in step 1.  This script is executed in SQL query analyzer.  If unsure how to do this, please review steps 6-7 of the original install instructions.  Be absolutely certain that you select the proper database in the drop-down menu before executing the script.
   
7. Once the above script has executed, you will see a number of messages indicating various rows were affected.  For example...(89 row(s) affected)  Scan all messages and make sure no errors occurred.  If an error occurred, email us the error and discontinue the upgrade.  If an error occurred you may wish to restore the database backup until we can resolve the issue.  If you see this warning message you can ignore it as it is not fatal:  Warning: The table 'tbl_newspro_SendQueue' has been created but its maximum row size (8403) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
   
8. If the database has successfully been upgraded, copy the CONTENTS (files and folders) from the folder called "eNewsletterPro" to the web folder where eNewsletter Pro is installed.  Typically this is http://www.yourdomain.com/enewsletterpro/.  Replace any existing files if prompted.  Be sure to include all sub folders including Admin, Bin, Images, User, etc.
   

Install Updated Delivery Engine and SMTP Express

Note: eNewsletter Pro version 7 no longer uses a Scheduled Task in order to send newsletters.  Rather, the software now runs as a service.  This will eliminate the need to reset the password each time the administrator password changes on the server.

1. Begin by first un-installing the version 2.5 mail engine.  To do this, find "Add/Remove Programs" in the Windows control.  Find "eNewsletter Pro Enterprise Edition" and click the Remove button.
   
   
   
2. Now install the version 7 mail engine by double-clicking "eNewsletterPro7.MSI" in the MailEngine folder.  Install the software into the same folder as the previous version.  The default is C:\Program Files\eNewsletterPro although you have have chosen a different drive in your last installation.
   
3. You should now reboot the server.  The installation script may prompt for a reboot.  If it does not, please proceed to reboot the server before continuing to step 3.
   
4. Once the server has rebooted, set the database connection so the mail engine can find the database.  Find the folder where you installed software ("c:\program files\eNewsletterPro\") and locate the file called db.txt.  Edit the file and specify the database connection. 

   Modify (LOCAL), youruserid,yourpass and the Database name if you did not call it "eNewsletterPro".  The fields to modify are shown below in Bold Italics.  The servernameorip can be set to either the name of the SQL server or the IP address.
   
   server=(LOCAL);UID=youruserid;PWD=yourpass;DATABASE=eNewsletterPro

   Note: If SQL is on the same machine, use (LOCAL) including the parentheses.  If SQL server is on another machine, use server=IPAddress where IPAddress is the IP Address of the SQL server.

5. If you will not be sending individual messages through a separate SMTP server, then you must set the permissions on the pickup folder by following these directions.
   
   

   Note: The Admin area is located in an /Admin/ folder.  The user login area is in a folder called "user".  It is HIGHLY Recommended that you add Windows level password protection to the entire ADMIN folder.  To do this, simply remove the anonymous web user account from the /admin/ folder.

   Admin console	/foldername/admin/default.aspx Ex. http://www.yourdomain.com/enewsletterpro/admin/default.aspx
   User console	/foldername/user/default.aspx Ex. http://www.yourdomain.com/enewsletterpro/user/default.aspx

Upgrade existing Data

1. Load the Upgrade.aspx file in your browser. It is located in the root folder and has open access.
   
   For example: http://www.yourdomain.com/enewsletterpro/upgrade.aspx
   
   Click the button to upgrade your existing database. This will encrypt the proper records.
   
2. Now delete upgrade.aspx so it cannot be executed a second time. 
   
3. Login to the admin console and user console to make sure the web interface is loading properly.
   
4. Update any forms used on your web site.  You can either re-create the forms within the eNewsletter Pro user console under Newsletters--Create Form, or you can simply modify the form to post to subscribe.aspx instead of members.asp.

Congratulations, the Upgrade is complete.