To set up your E-mail
account click on the "Setup Mail account" button. Doing this will bring up a
mail account properties screen like the one below.
Here you have a number of different
tabs. For my mail profile, I entered the following information on the "General"
As you can see, I entered the
"SQLMAIL" for the "Mail Account", "SQLMAIL" for the user name, and then
specified an E-mail, and E-mail reply address. The user name and addresses I
specified are the E-mail account and address associated with my POP3 account. After
I completed the mail account and user information I clicked on the Servers tab,
so I can define my mail server information. Once I have completed my mail
server information under the Servers tab the screen looks like this:
Here I have entered SERVER1
for the name of my POP3 and SMTP server. SERVER1 happens to be the name of my
SQL Server machine, and it is also running POP3 and SMTP services. In the
"Incoming Mail Server" field I enter my POP3 email account and password. Next I
completed the Connection Tab information.
Here you need to specify
what method you are using to connect to your POP3 and SMTP services. As you
can see I have selected the connection using my local area network. Lastly you
have the options of specify some advanced options, like port numbers, whether
you are using SSL, etc.
Now that you have setup your
mail profile you are ready to test to make sure your setup is correct and the
POP3 and SMTP services are working correctly. To verify that your SQL Server
machine can send mail using Outlook, start up your Outlook client on the SQL
Server machine, if prompted for a mail profile select the profile you just
created. Now try to send mail to yourself. After sending the mail go to your
workstation and verify that you have received mail from the mail account you
assigned to your new SQL Server mail profile. If the mail appears then you
correctly set up the mail profile on the SQL Server machine.