title: Replacing SQL Server 2005 Express Management Studio with the full version
body: <p>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.</p>
  
  <p>At first, I uninstalled SSMSE, and then ran <code>SqlRun_Tools.msi</code> to install the toolset. I got this error message:</p>
  
  <pre><code>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.
  </code></pre>
  
  <p>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, <a href="http://support.microsoft.com/default.aspx/kb/909967" rel="nofollow noreferrer">"How to uninstall an instance of SQL Server 2005 manually."</a> That bit was very successful.</p>
  
  <p>But when I attempted to run <code>SqlRun_Tools.msi</code> again, I faced this mess when the installer was "Preparing Installation Wizard":</p>
  
  <pre><code>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...
  </code></pre>
  
  <p><em>(but replace the asterisks with box chars, which were probably CR-LF's in the original message)</em></p>
  
  <p>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!</p>