Monday, July 12, 2010

Emily Haines Sheetmusic

Error Installing SQL Server 2008: Invalid value for INSTANCESHAREDWOWDIR

are installing SQL Server 2008 in a PC with Windows Server 2008 64 bit, I have found a bug that will not let me continue the installation. This error says INSTANCESHAREDWOWDIR not have a correct value.

After trying dozens of things, and read in various forums, it seemed that the solution was to run setup.exe from the command specifying a parameter, the correct value for it. But it does not work.

After a while, I found the solution that allowed me to install SQL Server 2008 on that machine:

  • Run \\ x64 \\ setup \\ x64 \\ SQLSysClrTypes.msi (found on the CD)
  • Clear this registry entry [HKEY_LOCAL_MACHINE \\ SOFTWARE \\ Microsoft \\ Windows \\ CurrentVersion \\ Installer \\ UserData \\ S-1-518 \\ Components \\ 0D1F366D0FE0E404F8C15EE4F1C15094 ]
  • Delete this registry entry [HKEY_LOCAL_MACHINE \\ SOFTWARE \\ Microsoft \\ Windows \\ CurrentVersion \\ Installer \\ UserData \\ S-1-5-18 \\ Components \\ C90BFAC020D87EA46811C836AD3C507F ]
Once done, I re-run the installation normally, and everything worked properly. In addition, the facility now has allowed me to change the path for the parameter INSTANCESHAREDWOWDIR, although I have not needed to change.