July 11, 2007 at 1:20 pm
hi all,
Have any one came accross with this error in SQL 2005? I am getting error in log for sending email notification when job fails.
log says:
Date 7/11/2007 2:01:46 PM
Log Database Mail (Database Mail Log)
Log ID 142
Last Modified 7/11/2007 2:01:46 PM
Last Modified By sa
Message
Activation failure.
Event viewer says:
The description for Event ID ( 9724 ) in Source ( MSSQL$SQLMEASP ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: [dbo].[sp_sysmail_activate], msdb.dbo.ExternalMailQueue, Could not create DatabaseMail90.exe process. Executing API 'CreateProcess' failed with error number 3..
What is the solution to this please. I have SQL 2005 SP2!
August 31, 2009 at 10:59 am
Hi,
I know its a very old posting, but we are having the same issue since today, so did you ever work out?
Regards,
Jan
September 3, 2009 at 5:57 am
Is this occuring on a clustered sql server instance?
MJ
September 4, 2009 at 1:00 am
Hi,
no cluster, its an Microsoft SQL Server Enterprise Edition (64-bit) Server with 3 named instances.
Regards,
Jan
March 17, 2010 at 8:39 am
I've seen a fix for db mail in a cumulative update for sp3, sql 2005. Is that it, by chance?
March 18, 2010 at 5:59 am
Other references in this forum that may be related to your issue:
http://www.sqlservercentral.com/Forums/Topic763709-146-2.aspx#bm861251
http://www.sqlservercentral.com/Forums/Topic522362-146-1.aspx
March 19, 2010 at 9:33 am
I think our infrastructure team just did a "repair" installation to fix it. Not a nice solution but it worked :-D.
Regards,
Jan
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply