Is there any problem if I have upgrade SSRS (hosted on server1) from 2014 to 2016 and its databases (which are on another server server2) are still on SQL Server 2014?
Asked
Active
Viewed 431 times
1
-
When you say "its databases" do you mean the ReportServer and ReportServerTemp databases, or the databases that the reports use as a datasource? – Alan Schofield Feb 18 '19 at 15:48
-
its reportserver and reportservertemp db – Sanky Feb 18 '19 at 16:08
-
I don't have a definite answer but my guess would be that it should work. The reportserver database might need to be updated but I think the database compatibility level can be anything from 110 onward (SQL 2012 onward) – Alan Schofield Feb 18 '19 at 16:13
1 Answers
0
You can use any supported version of SQL Server to host the databases.
From the docs:
Database server version requirements
SQL Server is used to host the report server databases. The SQL Server Database Engine instance can be local or remote. The following supported versions of SQL Server Database Engine can host the report server databases:
- SQL Server 2016 (13.x)
- SQL Server 2014 (12.x)
- SQL Server 2012 (11.x)
- SQL Server 2008 R2
- SQL Server 2008
David Browne - Microsoft
- 80,331
- 6
- 39
- 67
-
Thanks, I was confused that if it will update any tables structure as well while upgrading SSRS. – Sanky Feb 19 '19 at 14:09
-
The SSRS upgrade will perform any required changes to the table structure. – David Browne - Microsoft Feb 19 '19 at 14:27