Add SQL Server Management Studio to Microsoft SQL Server Express 2008 R2

When installing VMware vCenter 5 with the default database engine (Microsoft SQL Server Express 2008 R2) the SQL Management Studio is not installed by default. It can be confusing to add SQL Management studio at a later time. Here are the steps explained:

1. Download Microsoft SQL Express 2008 R2 (can be found here) or browse the vCenter installation ZIP or ISO. The installation package can be found in the “\redist\SQLEXPR” folder.

2. Select “New Installation or add features to an existing installation”.

3. Select “New installation or add shared features”.



– Only select “Management Tools – Basic”.



When the installation is completed you see the “SQL Server Management Studio” listed under the start menu.



Important to know is that you need exactly to follow these steps. If you choose the wrong option and  use the back button the “Management Tools – Basic” isn’t listed anymore. Strange….

Related posts:

Test Microsoft Hyper-V R2 server on your laptop with Virtual Hard Disk (VHD)
Sysprep goes wrong on Microsoft Windows 2008 R2 and Windows 7
VMware, Microsoft and Starwind software updates
Choosing between SQL 2005 Express or SQL standard/Enterprise for the VC database
Microsoft TechDays Belgium

server 2008 r2 management studio, sql server 2008 r2 management tools basic failed, sql server 2008 r2 management tools complete
Source: http://docphy.com/technology/computers/software/add-sql-server-management-studio-microsoft-sql-server-express-2008-r2.html