Share via

SCCM SQL vs RP SRSS versions

JG 396 Reputation points
2022-07-20T14:43:26.17+00:00

So currently my site server SQL DB is 2014 and my separate reporting point is still running SQL SRSS 2012
As 2012 is out of support i have to upgrade the SRSS. Since the RP is W2012R2, instead of having to also upgrade the OS, i was going to setup a new server to do this (since i have to remove the RP anyway.)
Can i setup a new server with SRSS 2019 and will this work with the existing site SQL DB of 2014?

Will there be an issue with the version difference until i get round to upgrading the site server SQL DB to 2019?

Thanks

Microsoft Security Intune Configuration Manager Other
0 comments
Accepted answer
  1. Garth 5,801 Reputation points
    2022-07-20T15:36:44.24+00:00

    Yes that will work without issues. aka SSRS using SQL 2019 and CM using SQL 2014.

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jason Sandys 31,406 Reputation points Microsoft Employee Moderator
    2022-07-21T16:39:31.343+00:00

    As a side note here -- not disagreeing with Garth's answer in any way -- but this isn't a ConfigMgr specific question or answer in any way. I can't find anything specifically in the SSRS docs that says a specific SQL Server version is required for a specific SSRS version. I do believe it should work just fine though and agree with Garth.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.