I have now implemented a 2008 SSRS clustered failover solution. If anyone interested read on.

The solution consists of a standard two node active passive cluster with multiple instances.

In brief;

1.SQL installed...

Thanks guys, specially GilaMonster for the link. 🙂

We've gone with the restoring to a reporting server and carrying out Integrity checks on there as the only available solution for us...

I'm not running it at all now, it was scheduled for once a week, but database increased rapidly to new functionality, so have only managed to run it once during...

I think what Brad is saying is ok for small companies where there is one or two DBA's, but most times its not a good idea with large companies where...

Thanks for your advice, The main reason I am looking at these two options is for automatic failover.

Mirroring with a witness server does this, however I am restricted to...

Thanks Lowell for your reply.

All

Thanks for all your advice.

I've started to mail them requests one at a time without giving them to much details, so that they call me back to figure out where they...

AJ

Basically, its their new security policy (no one other than themselves to have admin rights on servers).

As you mention supporting it would be a nightmare, specially when you get an...

Yes, but I've logged on directly to the server as the system administrator, then on to EM and created a new activeX task tried executing it, but does not work.

I've...

I have a weekly reindex job, is that not enough?

Thanks jmaurais, forgot about the obvious answers.

They are both using Standard Edition.

Its a good thing the DBA's did not order the extra memory.