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

What is wrong with my Distributor

 
   Database Help (Home) -> Notification Services RSS
Next:  NSService error  
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:
Is the trace flag (8720) needed? - I'm converting SQL7 to SQL2K. The database scripts have an statement: DBCC TRACEON (8720) It's from third party vendor for previous database build or update. I'd like to know if the trace flag 8720 still is needed for SQL 2K or not. If not, I'm going to....

High-level requirement for a pub-sub app - Thank you, Shyam, for your answer to my question regarding the distributor and delivery protocol objects. Your explanation was very helpful to me. Now I have another question for you and the group. I've been given a rough sketch of a possible futur...

Mapi error - I am trying set up notfication so it emails when jobs fail etcc. I am using sql server 2000 service pack 3A i have set up a mail profile and when I go into enterprise manger and go to test sql mail it says it opens and closes my mapi connection fine.....

How to get notification instance from another machine - Hi I want to run my webapplication at machine1, which should access the notification instance created at machine2. I dont see any server configuration in notificationservices properties. How this can be done? Thanks

Scheduled Notification - Hi, I am using scheduled customized event provider which looks for event every 2 minutes. Similarly i want to make notification to be scheduled, which will send notification every 2 or 3 minutes. One way is to add multiple subscription for..
   Database Help (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 ]