• Chris Harshman - Monday, March 5, 2018 10:51 AM

    Sometimes they've decoupled too much.  For example, I recently had to rename an Analysis Services instance for SQL Server 2016.  It's actually a fairly easy thing to do, but unfortunately the tool to do that is bundled with Management Studio, which wasn't installed on the server, so I had to install that client side program first to get the server side tool :hehe:
    https://docs.microsoft.com/en-us/sql/analysis-services/instances/rename-an-analysis-services-instance

    Why install the client tool on the server? Can no clients connect to the server? Or does this change only local instances? Either way, decoupling still makes sense. Install the client tool if you need it. I'd prefer the client tools be separate as well, so that if you need the SSAS tool, you don't need everything else.