Sorted!!

Here are the steps I have followed:

- Downloaded the correct patch (second one in the list)

- Upgraded my SQL Server

...

Sorry to reply to my own post but I have noticed the "SQL Server 2008 Reporting Services does not support state indicators" message displayed.

The problem is that we have installed...

Thanks for the info.

I was quite pressed for time and used my personal account which password never expires.

However we're in the process of reviewing our database storage and disaster recovery...

Solution:

The error appeared in the SQL Server logs but the issue was read permission on the shared drive.

I have modified the SQL Agent Service to user my network user/pwd and...

Hi

Sorry to reply to my own post but I have discovered that the secondary server fails to login to the primary server.

I get login failed for user "TOTO\Server2" [CLIENT: 10.0.0.YYY]

Therefore...

Ooops sorry about the formating guys.

Sorry to be so thick but I have tried different copy/paste and can't get the code to indent.

Help?

Ludo

Guys

Here is the solution:

I have used the WITH clause to mimic the original table. The solution is quite obvious when you think about it as the XML will be based...

I have the same issue and it drives me mad!!

Could you please provide us with the solution?

Cheers

Ludo

Hi

Phew what a nightmare but I got everything working now.

1-

In IIS my default webserver page was not setup properly which prevented all the reports from being run successfully.

2-

For the scheduling...

I'm ashame to admit it but ... even running the report normaly now fails with the same error.

Let me check what changes I have made to get this far and...

Hi

My report works fine when I call it directly from http://<server>/reportserver. I can see the results and save them in an Excel file locally.

When I get the e-mail...

Hi

Thanks you both for your support!

I have finally found the missing properties.

When you select the layout, you have the properties on the right which has a drop-down box at the...

Hi

Thanks for getting back to me.

I do apologise for not answering earlier but I was tied-up on another part of the project.

The error I am getting is the following one:

An...

Sorry to reply to my own post but this has now been sorted out.

I am ashame to admit that there was still a badly formed filter in another table which...

I think that now I have all the privileges under the sun.

I now need to re-attach the ReportingTempDB database.

I'll do it tonight out of core hours as this is a...