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 Configuration Manager
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,181 Reputation points Microsoft Employee
    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.