Blog

Blue Mountain RAM sends notification emails full of information. Examples include:

  • Your request REQ-000089 has been approved
  • The Asset Owner of Widget123 has changed from X to Y
  • Calibration work CAL-004123-2018 needs a review signature
  • The following schedules are coming due (list)
  • A new asset has been generated: Equip-0001237

Recently, we received a call to the Blue Mountain Technical Support inquiring about why notification emails stopped arriving. After reviewing possible explanations, it was discovered that the organization changed its mail server. Updating the Blue Mountain RAM installation with the name of the new mail server, enabled delivery to resume.

This blog shows where one goes to update mail server information, so notification emails continue sending. As a note, make sure the people who maintain your organization’s mail server know that Blue Mountain RAM depends upon it to send its mail.

What Exactly Happens Behind the Curtain?

The part you do not see – unless you configure it – is the chain of connections from the Blue Mountain RAM database storing the name of the SQL Server Database Mail Profile, to the SQL Server Database Mail Profile’s Mail Account storing the name of your organization’s mail server. This chain transfers the mail from Blue Mountain RAM to SQL Server Database Mail to your mail server, where it gets delivered.

Here are the A-B-C’s of ensuring yours works:

A) Give Blue Mountain RAM the name of the SQL Server Database Mail Profile

1. Logon Blue Mountain RAM, open the Go To menu, and select System Configuration

2. Expand: Sites > YourSite, and highlight Settings

3. Open Site Options and scroll down to the section labeled “Mail”

4. In “Mail Profile”, enter or update the name of the SQL Server Database Mail Profile

5. (If need be) Here is where to go in SQL Server Management Studio (SSMS) to see the name of the Database Mail Profile. You may need the assistance of your Database Administrator or IT.

  • Open SQL Server Management Studio & connect to the server.
  • Expand Management.
  • Right-click Database Mail & choose “Configure Database Mail”.
  • A wizard starts.
  • Choose “Manage Database Mail accounts and profiles”.
  • Choose “View, change, or delete an existing profile. You can also manage accounts associated with the profile”.
  • The name of the profile is listed in “Profile Name.”

B) Give SQL Server Database Mail Profile’s Mail Account the name of your mail server

1. Open SQL Server Management Studio & connect to the server

2. Expand Management

3. Right-click Database Mail & choose “Configure Database Mail”

4. A wizard starts

5. Choose “Manage Database Mail accounts and profiles”

6. Choose “View, change, or delete an existing account”

7. In “Outgoing mail server (SMTP)” section “Server name” field, enter or update the name of your organization’s SMTP Mail Server

8. Click NEXT, click FINISH, and read wizard end message, to verify success

C) Send a SQL Server Database Mail Test Message to prove that your organization’s mail server is accepting mail transfer from SQL Server’s Database Mail.

1. Open SQL Server Management Studio & connect to the server

2. Expand Management

3. Right-click Database Mail & choose “Send Test Message”

4. Enter your email address in “To:” and click “Send Test E-Mail”

5. When the test email arrives in your mailbox, you will know that Blue Mountain RAM Notification Emails can flow smoothly.

When you have questions, consult the Blue Mountain RAM User and Administrator Manuals. If necessary, please contact our friendly Support Technicians at techsupport@coolblue.com with questions. Also, please enjoy calling and speaking with your Regional Sales Manager (RSM) at 800-982-2388 if you are interested in Blue Mountain RAM ideas, training, or services.