If you select the client tools during the installation of a SQL Server 2008 clustered instance on the first node of the failover cluster, they’re automatically installed on any nodes that are added later via the Add Node option. You might remember that if you selected the client tools during the installation of a SQL Server 2005 failover cluster, they were installed on only the current node and you had to install the client tools separately on remote cluster nodes. If you didn’t install the client tools when you initially installed the SQL Server 2008 clustered instance, you can install them afterwards but the steps aren’t very intuitive. Let’s look at how to install the client tools separately using the SQL Server 2008 setup GUI or the command line.
To install the client tools using SQL Server 2008’s Setup GUI, follow the steps below:
- Start SQL Server 2008 Setup on the cluster node in which you want to install the client tools.
- On the Installation page, select New SQL Server stand-alone installation or add features to an existing installation. Don’t select New SQL Server failover cluster installation.
- On the Installation Type page, select Perform a new installation of SQL Server 2008. Don’t select Add features to an existing instance of SQL Server 2008.
- On the Feature Selection page, select the tools you want to install and continue through the rest of the setup process.
There’s just one problem with this method—you need to repeat the steps above on each cluster node you want the client tools to be installed on, and as you can imagine it can take a long time if you have more than four nodes. In such cases, I prefer the second method in which you install the client tools using a simple command line. To install the client tools from the command line or using a script, follow these steps:
- Install the basic SQL Server management tools, which include SQL Server Management Studio (SSMS) support for the SQL Server Database Engine, SQL Server Express, sqlcmd utility, and the SQL Server PowerShell provider, by running the following command from the cluster node in which you want to install the client tools: setup.exe /q /ACTION=INSTALL /FEATURES=SSMS
- To install the complete SQL Server management tools, which include SSMS support for SQL Server Reporting Services, SQL Server Analysis Services, and SQL Server Integration Services; SQL Server Profiler; Database Engine Tuning Advisor; and the basic version of the SQL Server Management tools, run the following command from the cluster node in which you want to install the client tools: setup.exe /q /ACTION=INSTALL /FEATURES=ADV_SSMS
Installing the client tools from the command line is simple and straightforward. Also, if you need to install the client tools on multiple cluster nodes, it’s much faster to write a simple command and execute it multiple times than it is to use the SQL Server Setup GUI.