all groups > sql server notification services > december 2004 >
You're in the

sql server notification services

group:

Mailing Error


Re: Mailing Error Joe Webb
12/16/2004 10:47:59 AM
sql server notification services:

Hi Partibha -

A few things to consider:

1) After changing the smtp server name in your config file, did you run
NSControl update?

2) If your using the localhost smtp server, the NS$<InstanceName>
service account must be an administrator on the local machine. Okay for
developing, not for production obviously.

3) If you are supplying the name of another smtp server, make sure it
can be resolved in DNS. You can try replacing the name with the IP
address to see if that's that problem. Again remember to run NSControl
update to affect the change.



HTH...
Joe Webb

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



[quoted text, click to view]
Mailing Error Pratibha
12/16/2004 5:23:22 PM
I am a newbie to notification services. I made an application. It works
perfectly but doesn't send email for notification. It returns following
errors:

"Description: The e-mail address or SMTP server value is not valid.
EventParameters:
Smtp server: localhost
Message recipients: pratibha@intraactionsoftware.com
Description: The message could not be sent to the SMTP server. The transport
error code was 0x80040217. The server response was not available
Description: Exception has been thrown by the target of an invocation.
Description: The message could not be sent to the SMTP server. The transport
error code was 0x80040217. The server response was not available"

"A delivery failure was reported.
EventParameters:
Distributor Id: 1
Distributor Name: TrialDist1
Delivery Channel Name: EmailChannel
Notification Id: 1
NotificationClassName: TrialNotifications
Notification Status Info: The e-mail address or SMTP server value is not
valid.
Smtp server: localhost
Message recipients: pratibha@intraactionsoftware.com
Notification Text: <html>
<body>
trading at: <b>$67.00000</b><br>
Click here to see the quote detail:
<br><br><i>Thank you for using SQL Server Notification
Services.</i><br><br></body>
</html>
Notification Sent Time: 12/16/2004 11:44:47 AM"

y'day it was working perfrectly. I changed my smtp server from localhost to
server still no luck.
Thanks

Re: Mailing Error Joe Webb
12/17/2004 9:46:12 AM
Hi Mukund -

If you're using the local smtp server on the dev box, your Delivery
channel should look something like this. Can you post the relevant
sections of your config file so we can have a look?

<DeliveryChannels>
<DeliveryChannel>
<DeliveryChannelName>EmailChannel</DeliveryChannelName>
<ProtocolName>SMTP</ProtocolName>
<Arguments>
<Argument>
<Name>SmtpServer</Name>
<Value>localhost</Value>
</Argument>
</Arguments>
</DeliveryChannel>
</DeliveryChannels>


Remember that you have to run "NSControl update" to update the
application with the new information in the configuration file. If you
specify the -verbose parameter, it'll show you what changes it's picked up.


When you say it's working on a server box, does that mean you've taken
the *exact* same XML files and compiled them on the server and it's
working there?

And (sorry to be repetitive, but it's worth doublechecking) you've
ensured that the service account that the NS$<InstanceName> service is
using to log in is a member of the administrators group?






HTH...
Joe Webb

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



[quoted text, click to view]
Re: Mailing Error Mukund Patel
12/17/2004 8:03:52 PM
Hi Friends,

I have followed all the following steps. But still I m getting same error on
SMTP. My machine is win 2000 professional. By the way same application is
working fine on win 2000 server. Is there any addinational configuration for
2000 professional?

Please let me know.

Thanks

-Pratibha


[quoted text, click to view]

AddThis Social Bookmark Button