Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Apr 30, 2004

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

By Gregory A. Larsen

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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM