eNewsletter Pro Enterprise Edition
SQL Installation Instructions

Unzip Files

1. Unzip the eNewsletterProEnterprise.zip file in a temporary location on the web server.  Do not place the file in a web folder.  A great place to unzip the files is in a folder on the desktop in /eNewsletterProEnterprise/
   
   You will then see these sub folders:
   /Database/
   /eNewsletterPro/
   /MailEngine/

Install Database on SQL Server

1. The eNewsletter Pro™ database is sent as script file and can be found in the /eNewsletterProEnterprise/Database/ folder.   Follow these directions to create the database.
2. Now add a user for this new database. 

Install eNewsletter Pro Mail Engine (The mail engine is responsible for creating the individual email messages and placing them in the queue for delivery.)
Note: Depending on the number and size of newsletters you are sending, you may require several GB of temporary hard drive space.  Be sure to install the mail engine on a drive with sufficient hard disk space.

1. On the web server, install the eNewsletter Pro mail engine and message delivery system.  To do this, execute the file located in the /eNewsletterProEnterprise/Mailengine/ folder.  Double-click the icon to begin the installation.  Install the software in c:\program files\eNewsletterPro\
2. Once the installation completes, execute under "Start-Programs-eNewsletter Pro" from the Windows start menu.
   
   
   A message will now indicate that no DNS server was defined:
   
3. In the system tray, RIGHT click the icon and select
   
   
4. Click the Routing folder.  Under DNS Server enter the IP addresses of valid DNS servers.  Separate multiple addresses using a comma.  You should specify at least TWO DNS servers.  This will be used to lookup the IP address of each domain that you attempt to send email.  This is a critical field as all email delivery depends on this field. 
5. Click the status folder then click Online to bring the Mail server online.
   
6. Click OK to exit the EasyMail Service Monitor.
7. Next, 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.  Use ONLY an OLEDB connection by modifying the connection string that is already present.  Modify yourdatasource, yourusername,yourpassword and the Database name if you did not call it "eNewsletterPro".  The fields to modify are shown below in Bold Italics.
   
   "PROVIDER=SQLOLEDB;Data Source=yourdatasource;UID=yourusername;PWD=yourpassword;DATABASE=eNewsletterPro"

Note: yourdatasource is NOT a DSN name, it is the name or IP address of the SQL server.  If SQL is on the same machine, use (LOCAL) including the parentheses.

Setup Newsletter Delivery Frequency/Bounce Checking (To check for newsletters in the queue as well as bounced email addresses, eNewsletter Pro runs in the background as a scheduled task.  The installation has created two scheduled tasks, however, before they will execute you must set the proper permissions.

1. Find the scheduled tasks icon in the Control Panel. 
2. Locate the task.  Double-click to edit the task.
   
3. Under Run as, enter the computers administator account.  Click Set Password and specify the administrator password.  Click OK when finished.
4. Verify that both the Run and Start in directories match the location where you installed the software.  They default to c:\program files\eNewsletterPro and must be updated if you installed the software in a different location.
5. Now repeat step 3 for the task.  This is the program that checks for bounces.
   
   Note:  By default the eNewsletter Pro Mail engine checks the queue every 2 minutes.  The eNewsletter Pro Bounce engine searches for bounces every 8 minutes.  You can change these frequencies by editing the scheduled tasks.

Install eNewsletter Pro Web-Based Interface

1. Determine the web site where you will install eNewsletter Pro.  This could be a new web site or a sub-folder in an existing  web site.
2. Copy the files from the /eNewsletterProEnterprise/eNewsletterPro/ folder into the web folder that will house the web interface. Be sure to INCLUDE all the subfolders (admin,databaseuploads,imageuploads,images).
3. Update the db.asp script to reflect your database connection.   Use an OLEDB connection by modifying the connection string that is already present.  Modify yourdatasource, yourusername,yourpassword and the Database name if you did not call it "eNewsletterPro".  The fields to modify are shown below in Bold Italics.
   
   NewsletterProConnectString="PROVIDER=SQLOLEDB;Data Source=yourdatasource;
   UID=yourusername;PWD=yourpassword;DATABASE=eNewsletterPro"
   
4. If you will allow users to upload images to attach to the newsletters, give the Anonymous user WRITE permissions on the folder called "uploadedimages".  Also do the same on the "databaseuploads" folder.  This folder is used to store temporary databases that are uploaded to import subscribers.  You should also give the anonymous users delete permissions on the databaseuploads folder so the databases are deleted after the data is imported.
   Note: For security reasons, turn off execute and script access on both these folders.  This will prevent a malicious user from uploading and executing a damaging script or executable.
   Click here for instructions on setting these permissions.
5. Run the eNewsletter Pro administration console in your browser.  The administration console is located in a folder called /admin/.  The default file name is default.asp.  For example, if you installed the software in a sub folder called enewsletterpro you can use... http://www.yourdomain.com/enewsletterpro/admin/ 
6. Login using Admin1 for the username and password.
7. Click setup and define the setup information including the license key that was emailed to you.
8. Note: 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 the root folder where you installed eNewsletterPro.  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.

IMPORTANT NOTE: Be sure that your computer has a Fully Qualified Domain Name (FQDN) so that other mail servers will accept messages from your server.  Click here for more information.

Installation is complete!