microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

A delivery failure was reported using SMTP Delivery channel

Subject: A delivery failure was reported using SMTP Delivery channel
From: TechJunkie
Date: Tue, 14 Aug 2007 21:26:29 -0000
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hello Group.
I am trying to use Notification system to Deliver SMTP Emails.
The SMTP server is local and configured to use anonymous
Authentication.

The Distributor is running on the same box as the SMTP and all other
Notification services.
The Windows Service is running under Local System Account.

I am receiving this error over and over again,
I went through a lot of blogs and can't figure it out.
 Please help me.

I am including a snippet of the ADF and ICF files
Thanks in advance

ICF Snippet

<DeliveryChannels>
    <DeliveryChannel>
      <DeliveryChannelName>SMTPServerAlertsDelivery</
DeliveryChannelName>
      <ProtocolName>SMTP</ProtocolName>
      <Arguments>
        <Argument>
          <Name>SmtpServer</Name>
          <Value> ab-bcd-wer.Domain.COM</Value>
        </Argument>
        <Argument>
          <Name>Bod oding</Name>
          <Value>utf-16</Value>
        </Argument>
      </Arguments>
    </DeliveryChannel>
  </DeliveryChannels>

ADF Snippet

<NotificationClass>
      <NotificationClassName>ABCD_AlertsNotifier</
NotificationClassName>
      <Schema>
        <Fields>
          <Field>
            <FieldName>ABCD_size</FieldName>
            <FieldType>int</FieldType>
          </Field>
          <Field>
            <FieldName>request_ABCD_size</FieldName>
            <FieldType>int</FieldType>
          </Field>
          <Field>
            <FieldName>ABCD_uid</FieldName>
            <FieldType>numeric(18,0)</FieldType>
          </Field>
        </Fields>
      </Schema>


      <ContentFormatter>
        <ClassName>XsltFormatter</ClassName>
        <Arguments>
          <Argument>
            <Name>XsltBaseDirectoryPath</Name>
            <Value>C:\alerts_db\Alerts\ABCDExternal_Alerts</Value>
          </Argument>
          <Argument>
            <Name>XsltFileName</Name>
            <Value>ABCDTransform.xslt</Value>
          </Argument>

        </Arguments>

      </ContentFormatter>
      <!--
        <ClassName>ABCDDiscrepancyFormatter.cs</ClassName>
        <AssemblyName>D:\DatabaseSQLServer2005\90\NotificationServices
\Alerts\AlertsContenFormatter\ABCDFormatter\bin\Debug
\ABCDFormatter.dll</AssemblyName>
        <Arguments>
          <Argument>
            <Name>ABCDConnectionString</Name>
            <Value>
              Data Source=abcd;Initial
Catalog=abcd;user=abc;password=abc
            </Value>
          </Argument>

        </Arguments>
          -->

        <Protocols>
          <Protocol>
            <ProtocolName>SMTP</ProtocolName>
            <Fields>
                <Field>
                                        <FieldName>Subject</FieldName>
                                        <SqlExpression>'For ABCD is Actual Team 
Size is:
'                 </SqlExpression>
                                </Field>
                                <Field>
                                        <FieldName>BodyFormat</FieldName>
                                        <SqlExpression>'html'</SqlExpression>
                                </Field>
                                <Field>
                                        <FieldName>From</FieldName>
                                        
<SqlExpression>'[email protected]'</SqlExpression>
                                </Field>
                                <Field>
                                        <FieldName>Priority</FieldName>
                                        <SqlExpression>'Normal'</SqlExpression>
                                </Field>
                                <Field>
                                        <FieldName>To</FieldName>
                                        
<SqlExpression>DeviceName</SqlExpression>
                                </Field>
                        </Fields>

          </Protocol>

  <!--      <Protocol>
          <ProtocolName>File</ProtocolName>
          <Fields>
            <Field>
              <FieldName>ABCD_size</FieldName>
              <FieldReference>ABCD_size</FieldReference>
            </Field>
            <Field>
              <FieldName>request_ABCD_size</FieldName>
              <FieldReference>request_ABCD_size</FieldReference>
            </Field>
            <Field>
              <FieldName>sch000_uid</FieldName>
              <FieldReference>sch000_uid</FieldReference>
            </Field>
          </Fields>
        </Protocol> -->
      </Protocols>
    </NotificationClass>



Event Type:     Error
Event Source:   NotificationServices
Event Category: None
Event ID:       6043
Date:           8/14/2007
Time:           3:13:18 PM
User:           N/A
Computer:       ab-bcd-wer
Description:
A delivery failure was reported.
EventParameters:
  Distributor ID: 1
  Distributor Name: ab-bcd-wer
  Delivery Channel Name: SMTPServerAlertsDelivery
  Notification ID: 2
  Notification Class Name: ABCDAlertsNotifier
  Notification Status Info:
  Notification Text:
  Notification Sent Time: 08/14/2007 19:13:18

InstanceName: Alerts
ApplicationName: FTLCh
Component: Distributor
ComponentDetails: DistributorName: ab-bcd-wer
Thread: 45


For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.


<Prev in Thread] Current Thread [Next in Thread>