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

Re: A delivery failure was reported using SMTP Delivery channel

Subject: Re: A delivery failure was reported using SMTP Delivery channel
From: Joe Webb
Date: Wed, 15 Aug 2007 04:17:18 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
On Tue, 14 Aug 2007 21:26:29 +0000, TechJunkie wrote:

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


Try replacing the fully qualified server name with localhost. Also, there
used to be a bug in the .net framework that required the service account
to run as admin when relaying email through the local machine. Try
elevating the service account's permissions. 

HTH...

-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com

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