sql server notification services: Intermittent email problem -- sql server notification services

You're in the

sql server notification services

group:

Intermittent email problem

RDV
10/25/2006 10:02:28 AM

sql server notification services: I am receiving the following error in the application event log file.
It only happens intermittently. The SMTP server and email addresses
are valid and available at the error times in question. This error is
followed by a delivery failure message.

Running SQLNS 2.0 SP1 on SQL Server 2000

Any ideas on what the problem could be ?

***************************************************************

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise
Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

Event Type: Error
Event Source: NotificationServices
Event Category: None
Event ID: 7301
Date: 10/25/2006
Time: 12:02:52 AM
User: N/A
Computer: S29ELOGB01
Description:
<NotificationServicesEvent>
<Description>
The e-mail address or SMTP server value is not valid.
</Description>
<Context>
<EventParameters>
<Smtp server>SMTP.TTRONICS.COM</Smtp server>
<Message recipients>billebob@ttronics.com</Message recipients>
</EventParameters>

</Context>
<Description>
Could not access 'CDO.Message' object.
</Description>
<Description>
Exception has been thrown by the target of an invocation.
</Description>
<Description>
The message could not be sent to the SMTP server. The transport error
code was 0x800ccc67. The server response was 421 4.7.0
s02aPPMaster.ttronics.com closing connection

</Description>
<Instance>MTIS</Instance>
<Component>Other</Component>
<ComponentDetails>
ComponentName: SmtpProtocol
</ComponentDetails>
<Thread>2128</Thread>
</NotificationServicesEvent>

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

Re: Intermittent email problem

Warren Brunk
10/25/2006 10:12:50 PM

Whenever I see something intermittently stop working I think tend to think
its Antivirus software.
If your antivirus is scanning the CDONTS.ddl at the same time as that SQL
Server is trying to access it to send the email then you might get an error.
The same thing happens when norton scans web.config files and causes a
recycle in worker threads and ruins your asp.net sessions.

It could be a long shot, but it might be worth exluding that file from your
virus scans.

thanks,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/

[quoted text, click to view]

Re: Intermittent email problem

RDV
10/26/2006 11:42:31 AM

Thanks for the insight. However, antivirus software is not currently
running on this system.

What is the best practice when using SMTP? Should I use a local SMTP
server and have it relay messages onto the main SMTP server or go
directly to the main SMTP server. What are the pros and cons of
either?

Thanks

[quoted text, click to view]

Re: Intermittent email problem

Joe Webb
10/31/2006 12:00:00 AM

Hi Roger -

The local SMTP server is good for development and testing, however
during production you'll most likely want to specify the actual SMTP
server rather than relaying through the local one. Using the local one
in production places an unnecessary burden on that server and will
likely degrade overall performance.

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

~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server notification services group.

home · blog · groups

Questions? Comments? Contact the dn