Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

Is it a supported configuration to be run a SQL 2008 reporting services server with a SQL 2005 database server?

Either way, where can I find supporting documentation?

share|improve this question
add comment

3 Answers

up vote 0 down vote accepted

No, you'll need to use a SQL 2008 server for the ReportingServices database. You can connect SSRS 2008 to pull data from a SQL 2005 server without issue.

share|improve this answer
    
Can you point me in the right direction so I can view supporting documentation? ( our answer is what I remember reading, and its what I told my mgr, but I havn't been able to find docs ) –  Russ Aug 4 '09 at 15:05
    
I'm finding a surprising lack of info confirming this. I saw something that says that if you want to use Sharepoint mode it requires a SQL 2008 server. My best suggestion would be to give it a try in a lab and see what happens to be sure. Then you can become the authorative source. –  mrdenny Aug 4 '09 at 21:28
    
Me?!? An authorative source. pish posh. ;-) I'll look into trying it out and see what happens. –  Russ Aug 5 '09 at 12:38
add comment

Unfortunately SQL Server Reporting Services might fail to work successfully even if the database version is different in service pack or build number detail.

In such a case you should upgrade the report server database.

So it is not possible to make it work a 2008 on a 2005 db

For SSRS you can find resources at SQL Server Reporting Services

share|improve this answer
add comment

Ignore the answers above yes youo can, check this on sql server 2008 r2.. http://msdn.microsoft.com/en-us/library/ms157300.aspx (afryer@microsoft.com)

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.