SQL MAIL and SQL Agent Mail using POP3 and SMTP - Page 3

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" tab.

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.