SQL mail Error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

SQL mail Error

Author

Topic

jcilissen
Starting Member

1 Post

Posted - 2005-03-18 : 10:18:05

Hi all

We have a problem with xp_mail
We have 2 SQL servers (one new installed) with the same databases and more or less the same configuration ( should be ) , they both use the same exchange server for sending mails

if we are running following query on the new server

EXEC master..xp_sendmail @recipients = 'jos@cilissen.be',
@echo_error = 'TRUE',
@query = 'SELECT * from POI',
@subject = 'BT Test '
GO

This works so SQL mail is right configured

but if we add an attachement it doesn't work

EXEC master..xp_sendmail @recipients = 'jos@cilissen.be',
@echo_error = 'TRUE',
@query = 'SELECT * from POI',
@subject = 'BT Test ',
@attachments = 'Test.csv',
@separator =';', @attach_results = 'TRUE', @width = 4000
GO

Then we got this error

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

on the old server this works

Can somebody help us out

Thanks

Jos cilissen

TSQLMan
Posting Yak Master

160 Posts

Posted - 2005-03-19 : 23:59:30

Does your operator user, and your SQL Server Service Account Have File Permissions on Disk where the attachment is? Look up your error messages on BOL, if I am not mistaken, that error is the security range of error, and will show up in your Windows Event Viewer, as an application error.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources