Hi All,
When I try to process my mail with xp_findnextmsg or xp_readmail or xp_sendmail i get these errors:
Server: Msg 18025, Level 16, State 1, Line 0
xp_findnextmsg: failed with mail error 0x80004005
Queries processed: 0.
Server: Msg 18025, Level 16, State 1, Line 0
xp_readmail: failed with mail error 0x80004005
Server: Msg 18025, Level 16, State 1, Line 0
xp_sendmail: failed with mail error 0x80004005
my configuration is:
ms sql 2000 sp3
outlook 2003 as mapi client
sql server is started under account for which mapi profile is configured
Does anyone know what is wrong, and how to solve this problem?
Thanksdid you check eventviewer application and system error logs? do you get any errors while using outlook directly on the box?|||i've found what was the problem. When outlook started it deny acces to personal folders file (*.pst) for any other programm or process. And in normal way when I close outlook it should "release" that file, but that not happend. So now before processing mail i have to run xp_stopmail procedure, in other way mail processing will not be possible. And by the way in sql server error log i have these errors
2004-01-31 12:09:40.59 spid59 Error: 1073759806, Severity: 1, State: 0
2004-01-31 12:09:40.59 spid59 Starting SQL Mail session...
2004-01-31 12:09:40.60 spid59 Error: 1073759778, Severity: 1, State: 0
2004-01-31 12:09:40.60 spid59 SQL Mail session started..
on microsoft tech net they say :
These are informational (severity = 1) messages due to starting SQL Mail with xp_startmail. With SQL Server 2000, SQL Mail automatically starts when you run xp_sendmail, so use of xp_startmail is not necessary. You can ignore these messages.
thanks
Wednesday, March 7, 2012
Mail processing problems
Labels:
database,
errorsserver,
level,
line,
mail,
microsoft,
msg,
mysql,
oracle,
process,
processing,
server,
sql,
state,
xp_findnextmsg,
xp_readmail,
xp_sendmail
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment