|Figure 1: Add a new email account in Outlook 2003|
|Click on the Add a New Account radio button, then on Next. The window in Figure 2 appears.|
|Figure 2: Setting up a test account in Outlook 2003|
|Enter the details of the email account you are going to use, including the POP3 and SMTP server names. If you don’t know these,
check the details of one of your existing email accounts, or ask your mail administrator or ISP.
Finally, make sure that the Remember Password box has a tick in it.
Click on the Test Account Settings button to open this window:
|Figure 3: Outlook tests your email account settings|
|If you hit problems at this stage, double check:
Once you've tested the account successfully, complete the setup of the email account, and then click Send/Receive in Outlook.
If everything's working, you should get an email message in your Inbox similar to the one in Figure 4:
|Figure 4: A test email message sent from Outlook|
This is the longest step, but it’s very simple.
First, open up SQL Server Management Studio. It doesn't matter if you do this on your own PC or on the server where database mail is going to be set up.
Open the Object Explorer and connect to the database server where you want to install database mail. Open up the Management node, right-click on the Database Mail node and select Configure Database Mail, as shown in Figure 5 below:
|Figure 5: Configure database mail in SQL Server Management Studio|
|After right-clicking on Configure Database Mail, the Mail Configuration Wizard splash screen will appear. Click on Next, and select Set up Database Mail, as shown below:|
|Figure 6: Configure SQL Server Mail with Database Mail Configuration Wizard|
|Click on Next to continue. If SQL Server tells you that The Database Mail feature is not available, click on "Yes" to enable it. The next thing you'll see is the New Profile form:|
|Figure 7: Database Mail Configuration Wizard - New Profile|
|Type a Profile Name of your choice, and an optional description. Click on Add and the window in Figure 8 appears:|
|Figure 8: Tell SQL Server Database Mail which SMTP mail account to use to send mail|
|Next, click on OK. The database mail account will be added to the mail profile.
You’ve probably noticed that several mail accounts can be added to a
profile. This is a great idea, because if one of your mail servers
crashes, SQL Server
can still send database mail. Built in resilience right from the