Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

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

Ignore the answers above yes youo can, check this on sql server 2008 r2.. (

share|improve this answer

Your Answer


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.