Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Microsoft SQL Server: Setup and Administration FAQ

Mail Configuration

How do I setup my SQL Server to use outlook to send and receive mail? by mrdenny
Posted: 18 Nov 03 (Edited 19 Nov 03)

og 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.

Back to Microsoft SQL Server: Setup and Administration FAQ Index
Back to Microsoft SQL Server: Setup and Administration Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close