Activation Failure

We recently upgraded SQL Server 2005 to SP 2 and now cannot implement Database mail. The message given is "Activation Failure" in the log. I have looked at the stored procedure "sp_sysmail_activate" and there is apparently a failure due to an invalid parameter. Can someone provide some direction regarding how to proceed?

Thanks.

could u pse post back the exact error from error log

Madhu

|||

Date 5/30/2007 9:36:02 AM
Log Database Mail (Database Mail Log)

Log ID 516
Last Modified 5/30/2007 9:36:02 AM
Last Modified By sa

Message
Activation failure.

I hope this helps.

Thank you.

|||

We have also recently upgraded to sql 2005 sp2 and are experiencing the same error.

Log Database Mail (Database Mail Log)

Log ID 139
Last Modified 6/7/2007 12:50:06 PM
Last Modified By sa

Message
Activation failure.

Does anyone have any suggestions on what be causing this problem and potential solutions.

Thanks

|||

FYI - I was trying to make this work on SQL Server Express and was getting the same error message.

This might be because it's not supported, according to: http://msdn2.microsoft.com/en-us/library/ms165636.aspx

I don't know, but thought I would share.

Cheers,

-Richard

|||

DBMail is not supported on the Express edition. Let me know if you're receiving this error for a !Express edition.

Cheers,

Dan

|||Did you have any luck with your database mail issue. I'm experiencing the same thing.|||

Hi,

I'm also having this issue - See here for my problem:

http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=1890943&SiteID=17

Wonder if anyone has a solution ?

Cheers

|||

We just upgraded to SQL2005 SP2 and since database mail will not function here as well. Any solutions to this issue?

Database Mail Logs:

Date 8/3/2007 7:00:07 PM
Log Database Mail (Database Mail Log)

Log ID 1646
Last Modified 8/3/2007 7:00:07 PM
Last Modified By sa

Message
Activation failure.

EventVwr Logs:

Event Type: Information

Event Source: MSSQLSERVER

Event Category: (2)

Event ID: 9724

Date: 8/6/2007

Time: 8:00:06 AM

User: N/A

Computer: SERVERNAME

Description:

The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'Error executing extended stored procedure: Invalid Parameter'

|||same problem here, anyone any ideas please?