x

SQLMail Configuration requirements

I need to configure SQLMail for the old project for which the migration planning is going on. To configure the SQLMail, I refer the following web link:

http://www.techrepublic.com/article/set-up-sql-mail-to-send-sql-server-alerts/5094201

From this link on the requirement, I have a question:

Initial Setup: (Taken from the article)

Before you configure SQL Mail, you'll need to configure a mailbox, mail profile, and a Windows 2000 account to start SQL Server. If you're using Exchange, you need a domain account. If you're using a basic POP3/SMTP mail server, you need a local or domain account. For the purposes of this article, I'll show you how to configure a POP3/SMTP mail server.

Here, it has been mentioned that For Exchange Server - Domain account required Basic POP3/SMTP mail server - Local or Domain account

My question is how to distinguish between Exchange & SMTP mail server, in other words what is the difference between them ? Could anyone please explain it ?

Thanks in Advance
more ▼

asked Jul 24, 2012 at 10:25 AM in Default

skan2dan1 gravatar image

skan2dan1
210 11 13 14

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Before you need to configure the Database mail on SQL Server , U need to configure the mail server ie by Exchange server or SMTP\POP3 Once you have your mail server you can start to configure the database mail.

For Database mail you need to create a Database mail Account and profile. below link will give you step by step method to configure the DB Mail

http://blog.sqlauthority.com/2008/08/23/sql-server-2008-configure-database-mail-send-email-from-sql-database/

Below link will help you u to understand between the mail server

link text

more ▼

answered Jul 24, 2012 at 11:40 AM

basit 1 gravatar image

basit 1
499 51 61 84

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x473

asked: Jul 24, 2012 at 10:25 AM

Seen: 709 times

Last Updated: Jul 24, 2012 at 11:47 AM