Once SQL is installed, the procedure I typically use is (on your server):
- Install Microsoft Outlook 2000 (plus current service packs, etc.)
- Set up a Windows Domain user to be used by the SQL Server and SQL Agent Services (see BOL for rights). If you already have a user set up for the SQL Server services then use that one!
- Set mailbox properties for this Domain user
- Log into your server as the Windows domain user you have set up for SQL Server
- Set up Mail Profile for Exchange using Outlook 2000
- Test e-mail
- Change SQL Server and SQL Agent Services to run as the Windows Domain user you have set up for SQL Server
- Restart services
- Select Mailbox profile in SQL Agent Properties
- Select Mailbox profiler in SQL Mail Properties
- Test e-mail from SQL Server
For More Information
- Dozens more answers to tough SQL Server questions from Tony Bain are available here.
- The Best Microsoft SQL Server Web Links: tips, tutorials, scripts, and more.
- The Best SQL Web Links
- Have a SQL Server tip to offer your fellow DBAs and developers? The best tips submitted will receive a cool prize. Submit your tip today!
- Ask your technical SQL Server questions -- or help out your peers by answering them -- in our live discussion forums.
- Ask the Experts yourself: Our SQL, database design, Oracle, SQL Server, DB2, metadata, object-oriented and data warehousing gurus are waiting to answer your toughest questions.
This was first published in May 2003