| title | Install Client Tools: Failover Cluster | ||
|---|---|---|---|
| description | Learn how to install client tools, such as SQL Server Management Studio, on a SQL Server failover instance. | ||
| ms.custom |
|
||
| ms.date | 12/13/2019 | ||
| ms.reviewer | |||
| ms.prod | sql | ||
| ms.technology | failover-cluster-instance | ||
| ms.topic | how-to | ||
| ms.assetid | 3c82d510-9798-46be-bebb-cac9bef56936 | ||
| author | MashaMSFT | ||
| ms.author | mathoma |
[!INCLUDE SQL Server] Client tools such as [!INCLUDEssManStudioFull] are shared features common across all instances on the same machine. They are backward compatible, with supported [!INCLUDEssNoVersion] versions that can be installed side by side. Only one version of the client tool exists on a node at a time.
If the [!INCLUDEssNoVersion] client tools are installed during setup on first node of the [!INCLUDEssNoVersion] cluster, they are automatically added to any nodes that may be added later to the instance of [!INCLUDEssNoVersion] using Add Node.
Important
[!INCLUDEssNoVersion] Books Online is not automatically added to the additional nodes added to the [!INCLUDEssNoVersion] cluster using Add Node. [!INCLUDEssNoVersion] Books Online can be installed manually on the nodes that you wish to have a local copy of [!INCLUDEssNoVersion] Books Online.
If you do not install the [!INCLUDEssNoVersion] client tools during the initial installation of the [!INCLUDEssNoVersion] cluster, you can install it later as described in the procedures below.
Installing [!INCLUDEssNoVersion] Client Tools Using the Setup User Interface
-
Insert the [!INCLUDEssNoVersion] 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 [!INCLUDEssNoVersion] stand-alone installation or add Features to an existing installation. Do not click New [!INCLUDEssNoVersion] 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 [!INCLUDEssnoversion].
-
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.
Installing [!INCLUDEssNoVersion] client tools at the command prompt
-
To install [!INCLUDEssNoVersion] client tools and [!INCLUDEssNoVersion] Books Online, run the following command: Setup.exe/q/Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/d7d73a3891e9fd50f0f4e4881fb04b8024672847/docs/sql-server/failover-clusters/install/Install /Features=Tools
-
To install only the basic [!INCLUDEssNoVersion] Management tools run the following command: Setup.exe/q/Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/d7d73a3891e9fd50f0f4e4881fb04b8024672847/docs/sql-server/failover-clusters/install/Install Features=SSMS. This will install [!INCLUDEssManStudio] support for [!INCLUDEssDEnoversion], [!INCLUDEssExpress], sqlcmd utility, and the [!INCLUDEssNoVersion] PowerShell provider.
-
To install the complete [!INCLUDEssNoVersion] Management tools, run the following command: Setup.exe/q/Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/d7d73a3891e9fd50f0f4e4881fb04b8024672847/docs/sql-server/failover-clusters/install/Install /Features=ADV_SSMS. For more information about parameter values for the features, see Install SQL Server 2016 from the Command Prompt.
Uninstalling [!INCLUDEssNoVersion] Client Tools
They appear in Add or Remove programs in Control Panel as [!INCLUDEmsCoName][!INCLUDEssnoversion], and can be removed from there. When you use Remove Node to uninstall an instance of [!INCLUDEssNoVersion] from the failover cluster, the client components are not uninstalled at the same time.