Configure SQLMAIL Problem

Trying to setup sqlmail on SQL Server 2005.  Both the sql service and the agent service are running using the Administrator account.  I setup Outlook 2003 on the server machine with an account for Administrator.  I can both send from and receive into this Outlook accont.

Defined a sql operator named Administrator which uses the new email account created.  However when I look at the Sql agent properties the Mail Session box is greyed out.  Also when I try to send a Test email to the Operator the message displayed is "The Sql Server Agent Mail session is not running".
rhhuntAsked:
Who is Participating?
 
Barry CunneyCommented:
In the following article it seems to indicate that SQL Mail 2000 needs Outlook 2000
http://support.microsoft.com/kb/263556

http://support.microsoft.com/kb/281293/EN-US
0
 
Barry CunneyCommented:
Is the MS Outlook profile you set up set as Default?
0
 
rhhuntAuthor Commented:
First I must correct the Question.  This is SQL Server 2000 and not 2005.  In answer to your question, when I right click the SQL Mail setting the profile setting is Outlook.  On this server the only Outlook user configured is the Administrator.
0
 
rhhuntAuthor Commented:
Think my mail client is ok.  This command runs fine on my server:

exec xp_test_mapi_profile outlook
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.