Skip to content

Latest commit

 

History

History
53 lines (35 loc) · 4.87 KB

File metadata and controls

53 lines (35 loc) · 4.87 KB
title Install Client Tools on a SQL Server Failover Cluster | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.reviewer
ms.prod sql
ms.technology install
ms.topic conceptual
ms.assetid 3c82d510-9798-46be-bebb-cac9bef56936
author MashaMSFT
ms.author mathoma
manager craigg

Install Client Tools on a SQL Server Failover Cluster

[!INCLUDEappliesto-ss-xxxx-xxxx-xxx-md] 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.

Installation procedures

Installing [!INCLUDEssNoVersion] Client Tools Using the Setup User Interface

  1. 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.

  2. 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.

  3. The system configuration checker verifies the system state of your computer before Setup will continue.

  4. On the Installation Type page, click Perform a new installation of [!INCLUDEssCurrent].

  5. 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

  1. 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/5e4ce7d458b6a7bd8e7e16d0da0f620d9e0e3f3a/docs/sql-server/failover-clusters/install/Install /Features=Tools

  2. To install only the basic [!INCLUDEssNoVersion] Management tools run the following command: Setup.exe/q/Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/5e4ce7d458b6a7bd8e7e16d0da0f620d9e0e3f3a/docs/sql-server/failover-clusters/install/Install Features=SSMS. This will install [!INCLUDEssManStudio] support for [!INCLUDEssDEnoversion], [!INCLUDEssExpress], sqlcmd utility, and the [!INCLUDEssNoVersion] Powershell provider.

  3. To install the complete [!INCLUDEssNoVersion] Management tools, run the following command: Setup.exe/q/Action=/proxy/https/github.com/MicrosoftDocs/sql-docs/blob/5e4ce7d458b6a7bd8e7e16d0da0f620d9e0e3f3a/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][!INCLUDEssCurrent], 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.

See Also

View and Read SQL Server Setup Log Files