Hello all - we're building a new server to house our Tessitura database that we're currently running SQL Server 2016 on. With SQL Server 2016, each component is a separate file and install though and with TStats and SSRS reporting and such I'm looking for clarification on our versions.
Should we update EVERYTHING (ssms, ssrs, etc...) to 2016? Would it conflict with TStats or the SSRS reports in the Tessitura client itself.
Just trying to stay ahead of the curve. Any input is appreciated.
RJ
Last I heard was that 2016 was supported as long as it was in 2014 compatibility mode. I would *expect* that related services (SSRS/SSAS) are included in this. (Can't wait for full 2016 compatibility — STRING_AGG() finally exists in T-SQL!)
I would note that SSMS 2016 is backwards-compatible to 2008, and you can always download it to install on your workstation without having to use the full SQL Server installation material (and IIRC the install material for 2016 doesn't even include SSMS anymore — you just download it from here). SSMS even comes with Profiler these days. I'm going to build a new server on 2016 sometime soon, and I'm expecting NOT to install SSMS on it at all.