SQL sendmail error

Hi Experts,

I am getting an error message when trying to email in SQL Server.

The code im using is:

BEGIN
Exec Master.dbo.xp_sendmail 'info',
@subject = 'New Web Enquiries',
@message = @TEXT_BODY,
@attachments = '\\matrix\codex$\Website_Enquiries.doc'
END

This code is within a stored procedure and used to work before we went active directory and now im getting the following error:

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

I also tried just starting and stopping the mail session but I am getting this error:

SQL Mail session started.
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x8004011d
Stopped SQL Mail session.

Any Ideas?
LVL 1
colin_palmerAsked:
Who is Participating?
 
JaffaKREECommented:
colin,

 take a look at this thread which seems to be the same problem.

http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21158494.html
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.