xp_sendmail and MS Outlook profile setup

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

xp_sendmail and MS Outlook profile setup

Author

Topic

johnsql
Posting Yak Master

161 Posts

Posted - 2008-02-03 : 09:33:38

Experts,
Please help me to solve the problem below. Thank you in advance.

When I run Master..xp_sendmail in SQL 2000 QA, I gett the following error.


Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80040106

I have a MS Outlook 2000 I can use to read and send mail. In SQL Server EM when I test the MS Outlook profile (under Management > SQL Server Agent > Mail Session > Mail Profile), I do not see any profile available in the drop down list in there; when I try to type in something and hit "Test", I get popup message saying:


Error 18025 xp_test_mapi_profile failed with mail error 0x80040106

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2008-02-03 : 14:11:57

you need to be running sql server/sql agent under a domain account. You need to then login to the server where you run sql server using this account and configure outlook to create the profile. after profile is created and you test that outlook can send email, restart sql server/sql agent and then re-test.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources