Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

What is wrong with my Distributor

 
   Database Forums (Home) -> Notification Services RSS
Next:  Association Rules Model  
Author Message
entrodus

External


Since: Sep 07, 2007
Posts: 2



(Msg. 1) Posted: Fri Sep 07, 2007 3:19 am
Post subject: What is wrong with my Distributor
Archived from groups: microsoft>public>sqlserver>notificationsvcs (more info?)

Hi all

First of all i would like to say that i am a newbie in SSNS,
For some reason i am stuck with a pre-build SSNS application that
doesn't seem to work.

After hours (days) of struggle i have managed to make it produce
notifications
(i can see data in both NSMyNotificationClassNotificationBatches1 and
NSMyNotificationClassClassNotifications)

Furthermore, i have tied the notifications to an SMTP channel which i
have defined as:

<DeliveryChannel>
<DeliveryChannelName>SMTPChannel</DeliveryChannelName>
<ProtocolName>SMTP</ProtocolName>
<Arguments>
<Argument>
<Name>smtpserver</Name>
<Value>10.1.212.212</Value>
</Argument>
<Argument>
<Name>bodyencoding</Name>
<Value>utf-8</Value>
</Argument>
</Arguments>
</DeliveryChannel>

This is the Distributor Data i have declared in the ADF file:

<Distributor>
<SystemName>ComputerName</SystemName>
<ThreadPoolSize>3</ThreadPoolSize>
<QuantumDuration>PT1M</QuantumDuration>
</Distributor>
</Distributors>


Everything was supposed to be working 6 months ago that this project
was finished.
So the Question is... why i am not getting any emails ?

The SMTP Server seems to be working fine (i used it to send some test
emails through outlook)
The NS$Notification Service is running under administrator privileges.

Any thought on would should i check?
Is there a hidden layer of something between the transaction tables
and the distributor?

 >> Stay informed about: What is wrong with my Distributor 
Back to top
Login to vote
entrodus

External


Since: Sep 07, 2007
Posts: 2



(Msg. 2) Posted: Mon Sep 10, 2007 12:15 am
Post subject: Re: What is wrong with my Distributor [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On 7 , 13:19, entrodus wrote:
> Hi all
>
> First of all i would like to say that i am a newbie in SSNS,
> For some reason i am stuck with a pre-build SSNS application that
> doesn't seem to work.
>
> After hours (days) of struggle i have managed to make it produce
> notifications
> (i can see data in both NSMyNotificationClassNotificationBatches1 and
> NSMyNotificationClassClassNotifications)
>
> Furthermore, i have tied the notifications to an SMTP channel which i
> have defined as:
>
> <DeliveryChannel>
> <DeliveryChannelName>SMTPChannel</DeliveryChannelName>
> <ProtocolName>SMTP</ProtocolName>
> <Arguments>
> <Argument>
> <Name>smtpserver</Name>
> <Value>10.1.212.212</Value>
> </Argument>
> <Argument>
> <Name>bodyencoding</Name>
> <Value>utf-8</Value>
> </Argument>
> </Arguments>
> </DeliveryChannel>
>
> This is the Distributor Data i have declared in the ADF file:
>
> <Distributor>
> <SystemName>ComputerName</SystemName>
> <ThreadPoolSize>3</ThreadPoolSize>
> <QuantumDuration>PT1M</QuantumDuration>
> </Distributor>
> </Distributors>
>
> Everything was supposed to be working 6 months ago that this project
> was finished.
> So the Question is... why i am not getting any emails ?
>
> The SMTP Server seems to be working fine (i used it to send some test
> emails through outlook)
> The NS$Notification Service is running under administrator privileges.
>
> Any thought on would should i check?
> Is there a hidden layer of something between the transaction tables
> and the distributor?

I found the answer...
It is not a distributor issue after all.
I checked the logs of the SMTP Server and found the following errors:

"Message delivery to the remote domain 'xxxxxx failed for the
following reason: The remote server did not respond to a connection
attempt."

 >> Stay informed about: What is wrong with my Distributor 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
NS & Email - what am I doing wrong? - OK - new guy here - following the tutorials, I've modified them to reflect my application's basic needs, and the notifications are coming to the htm file fine. I've now added a delivery channel, and updated myself (the only subscriber) and my device to....

NS2005 does not work. What's wrong? - M$ SQL 2005 ASP.NET application on the same PC raises the exception: "The registry entries for the specified instance of Notification Services could not be found." ??? The "specified instance" is freshly created, registered, up and ...

NS API Question - Is it possible to have an arseembly in SQL 2005 to expose the NS API? The idea is to have interfaces exposed as web services from SQL 2005 directly that allow for the management of NS subscriptions. This would allow the existing ASP.Net 1.1 code to cal...

Clean out??? - I was asked to look into a problem a customer was having , Turned out they moved SMTP server and in the process the generator got disabled. This was back in May. So I have that all squared away and now I'm looking for a quick way to clear out the..

sql mail integration - i have configured sql mail in sql server 2000. the mailid is also successfully getting tested. but when i execute the xp_sendmail command i get the following error Server: Msg 18025, Level 16, State 1, Line 0 xp_sendmail: failed with mail error..
   Database Forums (Home) -> Notification Services All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]