Replacing SQL Server 2005 Express Management Studio with the full version

Question

I have been running SQL Server 2005 Express Management Studio ("SSMSE"), and I now have a need to install the full version of Management Studio ("SSMS"). This is a known hassle, but I've not found a comprehensive way to carry it out.

At first, I uninstalled SSMSE, and then ran SqlRun_Tools.msi to install the toolset. I got this error message:

A component that you have specified in the ADD_LOCAL property is already
installed. To upgrade the existing component, refer to the template.ini
and set the UPGRADE property to the name of the component.

I had no idea what template.ini was. So I looked around, and decided to uninstall the rest of the minimal installation of SQL Server 2005 Express on my computer by following Microsoft's advice in KB 909967, "How to uninstall an instance of SQL Server 2005 manually." That bit was very successful.

But when I attempted to run SqlRun_Tools.msi again, I faced this mess when the installer was "Preparing Installation Wizard":

The setup has encountered an unexpected error in datastore. The action
is SetDialogs. The error is : Source File Name:
...\datastorecachexmlschema.cpp
**** Compiler Timestamp: Fri Jul 29 01:13:50 2005
****    Function Name: DataStoreCacheXMLSchema::initScopeRecord*****Sour...

(but replace the asterisks with box chars, which were probably CR-LF's in the original message)

This is very frustrating. Does anybody have any advice for installing the full version of SSMS over top of SSMSE? Any help you can provide would be greatly appreciated!

Solution 1

I have also installed SQL Management Studio before just using the SqlRun_Tools.msi package without any problems but I think if you have previously had any other SQL Server 2005 components installed then you will need to install the Setup Support Files first as this is probably what sets up the component installation sequence. This can be done either by installing from the SQL Server installation media or by running the sqlsupport.msi file as described in the Microsoft KB article.

Solution 2

I resolve this problem

Steps

1. Go to Add\remove program
2. unstall SQL server browser
3. Install support files from CD
4. Install SQL_Tools.MSI

Comments

[user2487501]

I recently went through the same thing last week. Good lord could they have made it a bigger pain in the you know what.

[eksortso]

My colleague ran SqlRun_Tools.msi and installed SSMS with no problems, even though he had SSMSE installed previously. He said that he just uninstalled everything SQL2K5-related before installation. You answered my question more succinctly then I did. You deserve an Up.