Can you post a screen shot of the selection page of the service pack with the engine clicked so we can see the details in the right hand column of...

Each dataset isrunning at exactly the same time which means that your global temp table isnt ready for the second proc to use it.

Try adding a wait for delay to...

Sounds like its already SP4, what do you get when you run SELECT @@Version?

Debug why your seeing so many extra connections, debug your 100% CPU usage using the guide, some good things to check on that.

But without some custom monitoring solution which is...

Clustering is not a DR technology, its a HA technology. You can use Geo clustering to provide DR but typically this costs a lot of money.

http://www.sql-server-performance.com/2002/clustering-intro/

I dont know why your connections are at 1500.

Could be a connection string is not closing connections down properly, could be 1500 users online at same time, could be a...

Diagnose why your CPU is at 100%, get a copy of the Accidental DBA guide link here[/url] which should help you diagnose the pressure.

You can create custom style sheets which you can put over the top of the default SSRS page.

Plenty on Google about it.

Edit.

Think that might be only for the report page...

when you connect to 2005 and run SELECT @@Version, what do you get?

Also running the right CPU edition of the service pack for the CPU of your server?

SSRS isnt cluster aware, but you could use scale out deployments if you have SQL Enterprise or some form of load balancing as its based on IIS.

Be careful when you...

Ensure that SPN's are configured on both servers as it could be a Kerberos double hop authentication issue.

I have a feeling the store number is an INT and therefore not appending the 0000 string to the front of it, so convert the store number to a char...

Get the 3rd party to add your account into SQL.

Or if you are Windows Server Admin, start SQL in single user mode and add in your account.

Sounds like you need to build a custom monitoring solution to fit your needs on that, as that information isn't readily available in SQL.

You could check sys.dm_db_index_usage_stats and that will...

Unfortunatly not good news again, another fail, again with a score of 624, so at least there is one thing, I'm consistant.

Think I will take a break from the certs...