Problem with xp_sendmail

Question

Post reply

Problem with xp_sendmail

vrkc

Ten Centuries

Points: 1165
More actions
October 24, 2006 at 12:56 pm

#62219

Hi,
We are running SQL server 2000 SP3 on a windows 2000 server. When i am trying to run the below code in a job, i am getting the following error
Executed as user: DomainName\XXXX_SQLSRV. xp_sendmail: failed with mail error 0x80040111 [SQLSTATE 42000] (Error 18025). The step failed.
Please help me out with this error. The app team does not want to use xp_smtp_sendmail
CODE:
SET NOCOUNT ON
GO
declare @support_listvarchar(100),
@sql_servervarchar(20),
@mail_subjectvarchar(100),
@mail_messagevarchar(500)
-------------------------------------------------
-- Build support list
-------------------------------------------------
set @support_list = (select c1
from t_control
where control_type = 'SUPPORT_DAY')
set @support_list = @support_list +
(select c1
from .t_control
where control_type = 'SUPPORT_PGR_SERVER')
-------------------------------------------------
-- Server Info
-------------------------------------------------
set @sql_server = (select c1 from t_control where control_type = 'SQL SERVER')
-------------------------------------------------
set @mail_subject = @sql_server + ' Testing'
set @mail_message = @sql_server + ' Testing'
select @mail_subject
select @mail_message
select @support_list
EXEC master..xp_sendmail
@recipients = @support_list,
@subject = @mail_subject,
@message = @mail_message

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

lucky-80472 SSCertifiable Points: 7793 More actions · Answer 1

Hello,

First things first,

1. Have you configured a mail profile with the domain account that the SQL Services are getting started?

2. Have you tested to send a test mail from T-SQL?

The reason for the error is that the mail profile is not configured with the account that it need to.

Hope this helps.

Thanks

Lucky

vrkc Ten Centuries Points: 1165 More actions · Answer 2

Hi Lucky,

Thank you for the reply. The mail profile is configured using the domail account. SQL server services and SQL server agent services are started using the same domain account.

When i tried to run the xp_sendmail from the query analyzer is am still getting

Server: Msg 18025, Level 16, State 1, Line 0

xp_sendmail: failed with mail error 0x80040111

i was simply trying to run this code

EXEC xp_sendmail @recipients = '5555555555@xxxx.com',

@message = 'The master database is full.',

@subject = 'Master Database Status'

Balmukund SSCertifiable Points: 6648 More actions · Answer 3

327552 BUG: SQL Mail Only Works From One Instance at a Time

http://support.microsoft.com/default.aspx?scid=kb;EN-US;327552

I would give a shot to delete and recreate mail profile.

vrkc Ten Centuries Points: 1165 More actions · Answer 4

Thank you for the suggestion and the article..i will try to do that

Andrew C Thompson Old Hand Points: 326 More actions · Answer 5

After modifying your mail profiles, you may need to issue "xp_stopmail" then "xp_startmail" from QA before the xp_sendmail will work properly.

maw74656 Old Hand Points: 326 More actions · Answer 6

We had a mailbox size issue in the account which was sending the emails. We had gotten a ton of "Unreachable recipient" messages. I deleted all those, then it worked fine.