Client tools are shared features which have ability to connect across all instances on the same machine.
Client tools to send queries and commands to the SQL Server Instance. Means, no data is stored in the client, SQL Server Database Engine holds the data which is installed on another machine.
To install SQL Client Tools we need to select only the below options:
Client Tools Connectivity
Client Tools Backwards Compatibility
Client Tools SDK
Management Tools – Basic
Management Tools – Complete
SQL Client Connectivity SDK
Installing SQL Server Client tools Installation using command line:
Setup.exe /q /Action=Install /Features=Tools,SSMS,ADV_SSMS
Features:
Tools- To install SQL Server client tools
SSMS- This will install Management Studio support for SQL Server Database Engine
ADV_SSMS- install the complete SQL Server Management tools
Client tools installation using Graphical Interface:
Client tools in SQL Server 2008 R2 version:
Client tools in SQL Server 2016 version:
We no longer see Management tools basic and complete in features selection from SQL Server 2016.
To Download & install SSMS on SQL Server 2016:
Open web browser and open this Download SQL Server Management Studio (SSMS) website
Connect to SQL Server Database Engine using IP address with port number with SQL Server credentials.
Ref:
https://docs.microsoft.com/en-us/sql/sql-server/failover-clusters/install/install-client-tools-on-a-sql-server-failover-cluster?view=sql-server-ver15