Use a SQL 2012 database server with Reporting Services 2008?
Hello, we have a SQL Server 2008 R2 Reporting Services Standard server with the reporting databases running on a SQL Server 2008 Standard database server. I would like to upgrade the database server to SQL Server 2012 before I upgrade the reporting server.
Can I run SQL Server 2008 R2 Reporting Services against a 2008-version database running on a SQL 2012 database server? Thanks for your help.
July 5th, 2012 7:27pm
Hello, we have a SQL Server 2008 R2 Reporting Services Standard server with the reporting databases running on a SQL Server 2008 Standard database server. I would like to upgrade the database server to SQL Server 2012 before I upgrade the reporting
server. Can I run SQL Server 2008 R2 Reporting Services against a 2008-version database running on a SQL 2012 database server? Thanks for your help.
Hi Nicole,
Yes, you can use SQL Server 2005 or SQL Server 2008 or SQL Server 2008 R2 or SQL Server 2012 to host the ReportServer database.
Shahfaisal Muhammed http://shahfaisalmuhammed.blogspot.com
Free Windows Admin Tool Kit Click here and download it now
July 5th, 2012 7:49pm
Hi Nicole
Thanks for your posting.
Are you asking if we can connect from SSRS 2008 r2 to a database sitting on SQL Server 2012. Am I right?, please ignore me if I misunderstood your question. If that is your question
then I think you will be able to using BIDS 2008, I have created A database on SQL Server 2012 and I use that database table inside my SSRS 2008 R2 dataset. I can even think that you can use a database of compatibility level of 2012(110) as well
Many thanks
Syed Qazafi Anjum
July 5th, 2012 8:07pm