Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

when I run xp_sendmail

exec master.dbo.xp_sendmail @recipients='me@hotmail.com', 
@subject='terrrible thing happened',  
@message='test'` 

I am getting an error

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

It is SQL Server 2000. Outlook is set on this box. I can send emails from the Outlook. It worked before. We just moved the server to DMZ.

We disabled Trendmicro antivirus's firewall

share|improve this question
    
Has this ever worked? –  gbn Aug 20 '11 at 11:01
add comment

2 Answers 2

Have you logged into the server with the account which the SQL service is running under, and configured outlook under that account?

share|improve this answer
    
Yes, I logged in as SQL Server account. Outlook works fine, I can email. SSMS>SupportServices>SQLMail>Properties>TestEmail works "sucessfully started and stopped a MAPI session with this profile" –  ob213 Aug 22 '11 at 14:47
    
Sysadmin opened some ports and that fixed an issue. –  ob213 Aug 22 '11 at 16:36
add comment
up vote 1 down vote accepted

Sysadmin opened some ports and that fixed an issue.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.