up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
100% accept rate
feedback

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.

link|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
feedback
up vote 0 down vote

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

link|improve this answer
feedback
up vote 0 down vote

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)

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

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