Can SQL 2008 reporting services work with the ReportServer databases on SQL 2012?
-
We are using a scale-out implementation of reporting services where the report server where the web component sits is different from the server hosting the ReportServer databases. Both are on SQL 2008 SP3.
We would like to migrate the instance hosting the ReportServer databases to a new SQL-2012 instance, but keep the web server on SQL 2008.
Does anyone know if reporting services would still work with the ReportServer databases on SQL 2012 and the web part on SQL 2008?
Has anyone tried it?
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url] -
I haven't tried it but it makes sense that it would work so long as the compatibility mode does not change for the RS databases.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events -
I have done this between SSRS 2008 R2 and SQL Server 2005 for the databases.
So in theory it should work OK on 2012 and 2008 R2
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply