?
Solved

SQL sendmail error

Posted on 2004-10-07
2
Medium Priority
?
817 Views
Last Modified: 2008-01-09
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?
0
Comment
Question by:colin_palmer
2 Comments
 
LVL 14

Accepted Solution

by:
Thandava Vallepalli earned 1500 total points
ID: 12247213
0
 
LVL 6

Expert Comment

by:JaffaKREE
ID: 12248480
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question