Sql-server – xp_sendmail: failed with mail error 0x80004005

sql-server-2000

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

Best Answer

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

Related Solutions

Sql-server – Sql 2000 attach Error 5172

The file's corrupt. You either need a backup, or you need to engage with a consultant who can try manually editing the file. (I'm not one of those consultants, and they're not cheap - you're in five-figure territory.)

Sql-server – SQL 2000 – tsql to find out failed jobs in last 24 hours

SELECT
    j.[name]
  , jh.run_date
  , jh.run_time
  , jh.sql_severity
  , jh.message
FROM
    msdb.dbo.sysjobhistory jh
INNER JOIN msdb.dbo.sysjobs j
ON  j.job_id = jh.job_id
WHERE
    jh.run_status = 0 -- Failure
AND jh.run_date > DATEADD(DAY, -1, GETDATE())
ORDER BY
    jh.run_date DESC

Best Answer

Related Solutions

Sql-server – Sql 2000 attach Error 5172

Sql-server – SQL 2000 – tsql to find out failed jobs in last 24 hours

Related Question