The Database Mail settings needed to allow the Monitor Orders Service to work will typically be defined initially by Mover’s Suite as part of its installation process. In the case that the service appears to not be working, then an administrator or IT professional can reference this section to help identify the source of the problem.
The Database Mail service available through Microsoft SQL Server Management is the process that Mover’s Suite uses to send an email automatically when a particular database value has changes.
The Database Mail option It is located within Management > Database Mail category for a specific database server.
Figure 16: Database Mail option
Double-clicking the Database Mail icon will produce the Database Mail Configuration Wizard. This utility will allow a user to modify the Database Mail settings. The following procedure can be used to validate the mail services ran through the database server.
Note: The procedure below is for reference only, an administrator or IT professional will need to know what the correct settings are for their particular company.
Validating Database Mail Settings
1. Access Microsoft SQL Server management,
2. Connect to the Database Server through Connect > Database Server and the Connect to Server dialog will appear,
3. Select the Server name from the available list,
4. Press Connect and the Object Explorer window will appear (see Figure 16),
5. Access the Database Mail options through Management > Database Mail,
6. Double-click on Database Mail and the Database Mail Configuration Wizard will appear,
7. Press the Next button if the Welcome page appears,
8. Choose the Manage Database Mail accounts and profiles option from within Select Configuration Task,
9. Press the Next button and the Manage Profiles and Accounts dialog will appear,
10. Choose the View, change, or delete an existing account option,
11. Press the Next button to view the Manage Existing Account options,
12. Verify that the following values are set:
a) Account name. By default, an account entitled “MoversSuiteDBMail” will be available. This account can be used or a new one defined,
b) E-mail address. This is the email address that is used to send the message with. It does not have to be valid email, as is the case with the default of “noreply@company.com” which implies a recipient not to reply to the message,
Figure 17: Default for E-Mail address and Display name
c) Display name. This is the name that is displayed for the sender of the message. By default it will be set to “Movers Suite Email”. This value will display in the From property of the message and can be modified to reflect a specific company or branch,
d) Reply e-mail. Optionally set an address to be used for replies to the sent message,
e) Server name. This is the name of the SMTP server that is used to send the email, such as “smtp.company.com”, for example,
f) Port number. Enter the port number of the SMTP server for the account. Typically, this will be set to “25”,
Note: The server name and port number are the same as those entered for the Email Options (refer to the SMTP Settings section),
g) Select the This server requires a secure connection (SSL) if the message will need to be encrypted using Secure Sockets Layer),
h) Choose from one of the following within the SMTP Authentication section:
• Select Windows Authentication using Database Engine service credentials if the connection made to the SMTP server will using the credentials configured for the SQL Server Database Engine server,
• Select Basic Authentication if the SMTP server requires a user name and password,
• Select Anonymous authentication if no authentication is needed.
13. Press the Next button and a verification page will appear,
14. Confirm that the changes are correct or press the Back button to edit,
15. Press the Finish when changes are complete,
16. Use the Report option to save a report of the changes made or to email the changes made to a user,
17. Press Close to exit the dialog.