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?
|||

Same to...

Additional information: after runnig DatabaseMail90.exe manualy, at DataBaseMailLog I have 2 errors:

Code Snippet

Date 21.09.2007 15:04:58
Log Database Mail (Database Mail Log)

Log ID 224
Last Modified 21.09.2007 15:04:58
Last Modified By WEST\freeman

Message
Invalid XML message format received on the ExternalMailQueue. conversation_handle: 408F6968-3268-DC11-8ADE-0015171170E8. message_type_name: {//www.microsoft.com/databasemail/messages}SendMailStatus. message body:
http://schemas.microsoft.com/databasemail/responses ResponseTypes.xsd" xmlns:responses="http://schemas.microsoft.com/databasemail/responses">

Code Snippet

Date 21.09.2007 15:04:58
Log Database Mail (Database Mail Log)

Log ID 225
Process ID 2032
Last Modified 21.09.2007 15:04:58
Last Modified By WEST\freeman

Message
1) Exception Information
===================
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 16
LineNumber: 1
Number: 6602
Procedure: sp_xml_preparedocument
Server: .
State: 2
Source: .Net SqlClient Data Provider
ErrorCode: -2146232060
Message: The error description is 'Switch from current encoding to specified encoding not supported.'.
The XML parse error 0xc00ce56f occurred on line number 1, near the XML text "<?xml version="1.0" encoding="utf-16"?>".
Data: System.Collections.ListDictionaryInternal
TargetSite: Void OnError(System.Data.SqlClient.SqlException, Boolean)
HelpLink: NULL

StackTrace Information
===================
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.SqlIMail.Server.DataAccess.DataAccessAdapter.PostResponse(Response r, Guid convHandle)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.PostResponseIfNeeded(MailInfo mi, Response r)
at Microsoft.SqlServer.Management.SqlIMail.IMailProcess.ThreadCallBack.MailOperation(Object o)

|||

Forgot

After runnig DatabaseMail90.exe manual leters from DatabaseMail query will sent.