locked
Error occures when sending mails through MSSQL Server 2005 Notification Server. RRS feed

  • Question

  • Hi All,
         I have configured the MS Notification server to generate mails once records added to a particular table. Following is the environment which i have configured for Notification server.
    OS  : Microsoft Windows Server 2003 R2 Enterprise x64 Edition Service Pack 2
    SQL : Microsoft SQL Server 2005 - 9.00.3042.00 (X64) Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

     But when the time notification generate email and trying to send it, it generates the following error. These are the consecutive error messages that were in the event log.

    ========================================================
    First Error
    ========================================================
    Description: The e-mail address or SMTP server value is not valid.
    EventParameters:
      SMTP Server: RiDMSQL.RSMAD.LOCAL
      Message Recipients: chinthaka@rsmad.local

    Description: Exception has been thrown by the target of an invocation.
    Description: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY))
    InstanceName: RDM
    Component: Other
    ComponentDetails: ComponentName: SmtpProtocol
    Thread: 4


    For more information, see Help and Support Center at


    ==========================================================
    Second Error
    ==========================================================
    A delivery failure was reported.
    EventParameters:
      Distributor ID: 1
      Distributor Name: Distributor
      Delivery Channel Name: EmailChannel
      Notification ID: 1
      Notification Class Name: LogNotification
      Notification Status Info: The e-mail address or SMTP server value is not valid.
    SMTP Server: RiDMSQL.RSMAD.LOCAL
    Message Recipients: chinthaka@rsmad.local
      Notification Text: <html>
      <body>
            An error occurred at the
        <b>Server</b>
        <br><br><p style="margin-left: 1.5em;">
        <b>Application</b>        : Mcd.Rdm.Server.BizTalk<br><b>Time</b>
        : 12/8/2009 3:04:00 AM<br><b>Error Message</b>    : The client - 40 has not sent any Heartbeat response for the last 20 minutes.<br><br></p>
      </body>



    I have a feeling that this happens due to service pack issue as one error saying "Error loading type library/DLL" (http://support.microsoft.com/kb/919224#top). But i don't have facts to say that straight away.

    If anyone know this error or how to fix this please let me know.

    Regards,
    Chinthaka.



    Wednesday, December 9, 2009 12:44 AM

All replies

  • Is there any suggestions.
    Tuesday, December 15, 2009 9:43 AM
  • You may want to double check to make sure that the SMTP server will respond to that domain.
    Joe Webb, SQL Server MVP | http://www.webbtechsolutions.com/blog
    Saturday, January 2, 2010 7:30 PM