Install Client Tools on a SQL Server Failover Cluster
Applies To: SQL Server 2016
Client tools such as SQL Server Management Studio are shared features common across all instances on the same machine. They are backward compatible, with supported SQL Server versions that can be installed side by side. Only one version of the client tool exists on a node at a time.
If the SQL Server client tools are installed during setup on first node of the SQL Server cluster, they are automatically added to any nodes that may be added later to the instance of SQL Server using Add Node.
If you do not install the SQL Server client tools during the initial installation of the SQL Server cluster, you can install it later as described in the procedures below.
Insert the SQL Server installation media. From the root installation folder, double click Setup.exe. To install from the network share, locate the root folder on the share, and then double-click Setup.exe.
On the Installation page, click New SQL Server stand-alone installation or add Features to an existing installation. Do not click New SQL Server failover cluster installation.
The system configuration checker verifies the system state of your computer before Setup will continue.
On the Installation Type page, click Perform a new installation of SQL Server 2016.
On the Feature Selection page, select the tools that you want to install and follow through the rest of the steps of the Setup process.
To install SQL Server client tools and SQL Server Books Online, run the following command: Setup.exe/q/Action=Install /Features=Tools
To install only the basic SQL Server Management tools run the following command: Setup.exe/q/Action=Install Features=SSMS. This will install Management Studio support for SQL Server Database Engine, SQL Server Express, sqlcmd utility, and the SQL Server Powershell provider.
To install the complete SQL Server Management tools, run the following command: Setup.exe/q/Action=Install /Features=ADV_SSMS. For more information about parameter values for the features, see Install SQL Server 2016 from the Command Prompt.
They appear in Add or Remove programs in Control Panel as MicrosoftSQL Server 2016, and can be removed from there. When you use Remove Node to uninstall an instance of SQL Server from the failover cluster, the client components are not uninstalled at the same time.