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 2

By Gregory A. Larsen

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.

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