How to setup for the SQL Database Mail to link with Exchange?

5 pts.
Tags:
Microsoft Exchange
Microsoft Outlook
SQL Server administration
How to setup for the SQL Database Mail to link with Exchange?

Answer Wiki

Thanks. We'll let you know when a new response is added.

Log into the SQL Server with an account that has Administrator privileges on the server.
Install Outlook.
Log into the SQL Server with the NT Account that the server is running as. (If the SQL Server is running under the system account, you will need to change it so that it is running under a Domain Account. This account will need to be granted the ability to log on as a service.)
Configure an outlook profile (you will need a mailbox on your exchange server for the SQL Server to use).
Open Enterprise Manager, and navigate to the server that you are configuring.
Right click on the server and select properties.
Click on the “Server Settings” tab.
In the SQL Mail section click change, and select the profile that you just configured from the drop down menu. (If it is not listed, or the drop down list is empty, you will need to stop and restart the SQL Service).
Once you have the Outlook profile selected, click ok. Then click ok to close the SQL Server Properties.

To configure SQL Agent, click the plus next to the server, and the plus next to Management.
Right click on SQL Server Agent, and click properties.
On the general tab, in the Mail Session section, select the Outlook profile in the dropdown. Click Test then OK. If prompted to restart the Agent, click yes.

Your SQL Server is now configured to send mail.

(This is from an FAQ I wrote <a href=”http://www.tek-tips.com/faqs.cfm?fid=4452″>here</a>.)

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following