Novar Database Mail Setup Guidelines

(1)

Delivering the Moment

Novar™ Database Mail

Setup Guidelines

(2)

Publication Information

Imagine Communications considers this document and its contents to be proprietary and confidential. Except for making a reasonable number of copies for your own internal use, you may not reproduce this publication, or any part thereof, in any form, by any method, for any purpose, or in any language other than English without the written consent of Imagine Communications. All others uses are illegal.

This publication is designed to assist in the use of the product as it exists on the date of publication of this manual, and may not reflect the product at the current time or an unknown time in the future. This

publication does not in any way warrant description accuracy or guarantee the use for the product to which it refers. Imagine Communications reserves the right, without notice to make such changes in equipment, design, specifications, components, or documentation as progress may warrant to improve the performance of the product.

Trademarks

Product names and other brands are trademarks or trade names of Imagine Communications or its subsidiaries. Microsoft® and Windows® are registered trademarks of Microsoft Corporation. All other trademarks and trade names are the property of their respective companies

Contact Information

Imagine Communications has office locations around the world. For locations and contact information see:

http://www.imaginecommunications.com/contact-us/.

Support Contact Information

For support contact information see:



Support Contacts: http://www.imaginecommunications.com/services/technical-support/

(3)

Purpose ... 4

Guidelines for SQL Server 2005/2008 ... 4

Steps to configure database mail ... 4

Create SQL Server Job ...13

Adjust the properties within the SQL Server Agent ...14

(4)

Purpose

This document is intended to be a basic guide for setting up a Database mail in order to send

notifications in case of SQL Agent job failures.

Guidelines for SQL Server 2005/2008

Steps to configure database mail

Given below are the steps to configure database mail:

1. Open SQL Server Management Studio (SSMS), connect to the Database Engine, expand

(5)

2. In the Welcome to Database Mail Configuration Wizard screen, click Next

(6)

(7)

(8)

6. Fill in the correct information as show below:

• Email address– This should be the sender email address.

• Display name– Type the name to show on e-mail messages sent from this account. The display name is optional.

• Reply e-mail– Type the e-mail address that will be used for replies to e-mail messages sent from this account. The reply e-mail is optional. For example, replies to an account for SQL Server Agent may go to the database administrator.

• Server name– Type the name or IP address of the SMTP server the account uses to send e-mail. Typically this is in a format similar to smtp.<your_company>.com. For help with this, consult your mail administrator.

• Port number– Type the port number of the SMTP server for this account. Most SMTP servers use port 25.

• SMTP Authentication– Leave this section set to the default, but you can specify it to your needs if it is required.

(9)

(10)

(11)

(12)

10. Click Finish.

(13)

testing and click Send Test E-Mail.

13. You will then see the screen below.

If the email doesn’t arrive, check the mail server to make sure it is properly configured and will accept mail from the SQL Server.

(14)

At this point we know the SQL Server can send email. Now we need to setup a SQL Job and then set

SQL so it sends emails if the job fails.

(15)

Enable mail profile. Ensure the correct Mail profile is selected. Click OK.

3. Restart the SQL Server Agent service.

(16)

1. Under the SQL Server Agent, right-click Operators and select New Operator…

2. Type in the recipient Name and email address in the E-mail name and click OK.

(17)

Novar Database Mail Setup Guidelines

Delivering the Moment

Delivering the Moment