Post reply

Database Mail - Activation Failure

  • June 13, 2012 at 4:52 am

    #262394

    Hi,

    I am using SQL server 2008 Standard edition (64-bit). My database mail was working fine few days back. But now on sending any mail it logs "Activation failure" in the database mail log and no mail is send. There have been no changes in the mail profile.

    Date6/13/2012 3:54:55 PM

    LogDatabase Mail (Database Mail Log)

    Log ID90

    Last Modified6/13/2012 3:54:55 PM

    Last Modified Bysa

    Message

    Activation failure.

    What's wrong with it?

  • June 13, 2012 at 5:21 am

    #1500268

    when i googled the same error, the first few i looked at all implied that a service pack was applied, but somehow some of the post-install scripts failed to execute; an MVP said it was fine to run the specific scripts manually;

    What I saw so far said it was common for SQL 2005 when getting SP2, but there are others with the same issue, and the solution was still to run a specific script.

    could your server have been patched recently, and that's possibly why the Activation Error is occuring? you posted in SQL 2008 forum, so i'm assuming you are 2008, right?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • June 13, 2012 at 5:56 am

    #1500286

    Yes I have 2008 standard edition (as i have already mentioned). There has been no patching done before the problem occured.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply