sql serversql server 2014ssasssas-2016
Should I expect any problems installing a SQL Server Analysis Services 2016 tabular instance next to a SQL Server 2014 database engine? (e.g. due to an update of some shared components)
I'm mostly worried about any issues related to the running database engine.
Thanks.
Late yesterday (7/8/2015), the Microsoft SQL Server Engineering Team confirmed that the Analysis Services hotfixes were indeed missing from the release of this CU. They intend to fix this in CU2 for SQL Server 2014 SP1. More information in the update message on the bottom of their blog post: link to SQL Release Services blog entry
The easiest way is :
using SSMS -- connect to instance --> reports -> standard reports --> General
There are other ways as well - How to find Analysis Services Server Version ?.
Best Answer
It is best to keep a server dedicated to a single version of SQL Server and/or its components. You can run into connectivity issues or have components stop working as expected due to the mismatched version of the shared components. I recently had an instance where someone upgraded the SSIS components and prevented us from opening packages properly on that box any more.
Additionally, if you can avoid it, keep SSAS and the engine separated as both do not like to share resources properly. You could end up with performance issues if you do not configure things properly.