Wed, July 13 2011 16:27
I don’t know how many times I have run into the situation where I have installed SQL Server Express 2008 and now need to install SQL Server Express Management Studio 2008. Each time it takes me a while to figure it out and then, in my exhilaration, I forget to document it only to tear my hair out (whatever’s left of it) the next time I am in the same situation.
Well, this time I am documenting this, if nothing else, for the sake of my own sanity and scalp.
The trick is to NOT choose the option to, “Add features to an existing instance of SQL Server 2008”!
After you launch the installer, choose Installation from the “SQL Server Installation Center” and select, “New SQL Server stand-alone installation or add features to an existing installation.”
Wait for SQL Server to process the operation, finish the process and run the “Setup Support Rules/Files”. Complete the process and choose, “Perform a new installation of SQL Server 2008”. Click through the wizard until you get to see the “Shared Features” and check/select the “Management Tools – Basic” option.
Complete the installation.