This tool can pull RDL files off of a report server and create a Visual Studio (same thing as BIDS) project for you:

http://www.sqldbatips.com/showarticle.asp?ID=62

Someone else on this forum posted this somewhere...

Thanks for pointing me to the Execution Log, I think this is probably the direction I need to go for troubleshooting this further.

In BOL, it says, "To view report...

Yes, currently the reports do aggregate in T-SQL in the stored procedure. I agree and accept that T-SQL can aggregate faster than SSRS at render time. Despite using this performance...

This may or may not be your issue but check here just in case:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/5049fc44-0f44-4caf-9c5a-282edf30d878/

This happened to me on two 2008 R2 clusters I built in the last few weeks....

I've built a 2008 cluster earlier this year and two R2 clusters in the past few weeks so I'll throw out some links that helped me.

SQL Server 2008 R2...

Yes, in fact both reports do exactly. I'm aware of that trade-off though I don't care for it as it makes for much longer stored procedures and messy reports to...

GilaMonster, you are so right. Unfortunately the vendor of the ERP system won't support any kind of replication because they've, "never tested it".

After reading that thread, I think I...

Disregard my above post. I figured this out. The solution, or perhaps more correctly, the correct way to install cumulative updates and service packs is to install on the passive...

According to the SQL Server 2008 Clustering Whitepaper, adding SSAS to a failover cluster is not supported. I'm disappointed but like I said, I can install it on separate server...

Sure.

I recommend making a database role and selecting the individual views you want these users to be able to see. Then map these uses to that newly created database...

It wouldn't be possible to maintain your passive node as a passive node during the upgrade, I agree.

However, one idea might be to drop the passive node out of...

That's what I started with and out of frustration and much head banging on the desk I looked up the stored procedures involved in setting up a linked server in...

One is a SQL Server 2008 Enterprise x64 and the other is SQL Server 2005 SP2 x64. They each must have links to each other.

This is what I ran and it's not changing a thing. It says it runs successfully but has no effect on my problem.

sp_addlinkedsrvlogin @rmtsrvname = 'REMOTESVRNAME'

...

This is the way SharePoint is designed. You're going to have to plan for continued growth of that content databases. Depending on the size of your organization you and/or your...