Problems with xp_startmail

[levinll]

I get the following error message when I try to use xp_startmail:

Server: Msg 17952, Level 18, State 1, Line 0
Failed to start SQL Mail session. Check the errorlog file in the SQL Server directory for details.

What's interesting is that I can successfully send emails when a scheduled jobs completes.

 

[sunila7]

Hi,

Have a look at this link in MSDN....

http://support.microsoft.com/default.aspx?scid=kb;en-us;248431

Hope it helps........


Sunil

 

[levinll]

Looked at the link and everything appears to be set up properly. Any other ideas ?

 

[tlbroadbent]

The reason the job sends mail while xp_startmail fails is because SQLAgentMail is configured separately from SQL Mail.

I think the following link should prove helpful in solving the problem.

http://support.microsoft.com/default.aspx?scid=kb;

[LN];311231 Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm

If you want to get the best answer for your question read faq183-874.