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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics