Help With Scheduled Reports

When i set up a subscription i get the following error
Failure sending mail: The Report Server has encountered a configuration
error; more details in the log files
I have found the following on MSDN
http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
The above details fixes for 2000 and 2003 domains however we are on a NT
domain
When i change the account to a domain account (even administrator) when it
is time for the subscription to run it does not execute
does any body have any ideas on how to fix this
thanks
RegWe had the same issue awhile back. Make sure you're up to date on your
service packs. Also, you can check the log file (ReportServerService) for
more error messages and details.
"Reg Besseling" wrote:
> When i set up a subscription i get the following error
> Failure sending mail: The Report Server has encountered a configuration
> error; more details in the log files
> I have found the following on MSDN
> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
> The above details fixes for 2000 and 2003 domains however we are on a NT
> domain
> When i change the account to a domain account (even administrator) when it
> is time for the subscription to run it does not execute
> does any body have any ideas on how to fix this
> thanks
> Reg
>|||It appears that applying MS05-043 , MS05-038 and MS05-039 caused the issue
to start as all was working before
"daw" <daw@.discussions.microsoft.com> wrote in message
news:CA6823E7-640E-4E86-B59F-65049301D885@.microsoft.com...
> We had the same issue awhile back. Make sure you're up to date on your
> service packs. Also, you can check the log file (ReportServerService) for
> more error messages and details.
> "Reg Besseling" wrote:
>> When i set up a subscription i get the following error
>> Failure sending mail: The Report Server has encountered a configuration
>> error; more details in the log files
>> I have found the following on MSDN
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;842423
>> The above details fixes for 2000 and 2003 domains however we are on a NT
>> domain
>> When i change the account to a domain account (even administrator) when
>> it
>> is time for the subscription to run it does not execute
>> does any body have any ideas on how to fix this
>> thanks
>> Reg
>>

Help With Replication Configuration

Hi
I have not had much luck setting this up. Here is my
situation.
I have 3 stores which have inventory. Each store updates
their own inventory every few hours. I want all stores to
be able to see inventory from all stores.
I want this to be as close to real time as possible. I
used transactional replication with queued fail-over. I
set up Store A as the publisher and pushed subscriptions
to store B and C.
Here is my problem. When data is updated at store B it
overwrites the databases at A and C instead of just
syncing them. Same happens with A and C as they update in
a round robin fashion every few hours.
How can I set this up so A, B, and C can each update
their own inventory yet see everything from the other
stores?
Basically I want A,B and C to be in sync all the time.
Thanks
Sal DiStefano
Sal,
there are different ways to set this up, but the easiest is to have separate
tables for each store and have a view at each store that unions the 3
store's data. Replication is typically implemented using merge, with each
table being published separately. Technically it doesn't matter who is the
publisher as you ensure the store records can only be changed at the host
store.
HTH,
Paul Ibison