Thanks Derek, I'll try that as soon as I get a minute.

Seems to make sense

Yes, I installed the 32 bits version

Thanks!

😀

I was more thinking of forum to try and debug this installation...

No joy... :crazy:

I have installed my reports on another laptop running SSRS 2005 as well and everything looks fine on it!

I'll try re-installing my reports from scratch on my Dev machine...

Yes. As far as I can tell, the situation is:

- main report works fine in Visual Studio (2005), on SSRS 2005 and SSRS2008R2

- sub report works fine in Visual Studio...

Tried that but no joy.

I have several reports calling this one sub report and they all who the problem...

Things seem to be working fine now on this server, although slow.

At times, latency was ~30 seconds.

However, as long as it works I am not too bothered because it's just...

Yes, both Publisher and Distributor are on the same server.

Thanks for your help. I'll look at this on Monday!

Have a nice week-end

Eric

Having sorted that issue, things are looking brighter now...

I am not too impressed with the latency of 3'45" (!) but this machine is simply doing it's best... 😀

Damn!

Looking at the Snapshot Sql Server Agent, I can see the job fails on authentication...

The job failed. Unable to determine if the owner (SSPUK\eric.mamet) of job FOXDWH-DEV01-FoxDW_DataWarehouse-SecurityData-15 has server...

Oopss!

I just realised that Object Explorer showed 2 subscriptions to my publication when looking at the publisher server side while it only shows one subscription to that publication when looking...

That could be a problem otherwise since we have started using a third party backup tool

No I think it was setup to perform a snaphot