Setting Up Mail Profile
As with using Exchange as
your mail server, the SQL Server machine will still require you to install an
Outlook Client and setup a mail profile to use POP3 and SMTP. The following
screenshots will walk you through setting up a mail profile.
Prior to setting up your
mail profile, first logon to your SQL Server machine with the account used to
start SQL Server and SQL Agent. If SQL Server and SQL Agent are different
accounts then you will need to set up a profile under each login. Next you
will need to display the available mail profiles on your SQL Server machine.
This can be done by going into Control Panel, clicking on the Mail icon, and
then selecting the "Show Profiles" option. A screen similar to the one below
should be displayed.
On this screen shot you can
see I have a single mail profile called "MS Exchange Settings". This is the mail
profile currently being used to allow SQL Mail and SQL Agent mail to send and
receive email via Exchange. On my machine I decided I wanted to setup a new
mail profile for SQL Mail and SQL Agent to use. To set up this new profile you
need to click on the "Add..." button. When doing that the Microsoft Outlook
Setup Wizards will be displayed.
On this screen you want to select
the check box for Internet E-Mail. This will cause the "Next" button to be
un-grayed, so you can click it to display the next screen in the process of
setting up a new profile. When clicking on the "Next" button the following
screen will be displayed.
On this screen a system
generated "Profile Name" is displayed. In my case I wanted to create a profile
name of "SQLMAIL", so I replaced the system generated name with "SQLMAIL".
Once a profile name is entered click on the "Next >" button to go to the
next step, which is setting up an Internet E-mail account.
» 
