While attempting to install SQL 2008 R2 64-bit, I can get as far as the
screen for selecting features. That screen has textboxes for the
INSTALLSHAREDDIR and INSTALLSHAREDWOWDIR locations. No matter what I put on
the setup command line, these locations are always the same and always grayed
out so that I can't modify them.

When I attempt to go past this screen, I get an error message that the
INSTALLSHAREDWOWDIR location is invalid and that these two locations must be
different.

This is an example of the setup command line I've been trying (one of many.)
/action=Install /INSTALLSHAREDWOWDIR="C:\Program Files (x86)\Microsoft SQL
Server Shared" /INSTALLSHAREDDIR="C:\Program Files (x86)\Microsoft SQL Server"

Is there a workaround for this?

In a similar situation while installing SQL 2008 64 bit on Windows 2003 64
where some DLLs for SQL-Server 2005 had been installed by another program,
I'd to delete a registry key as indicated in the last comment to the post
https://connect.microsoft.com/SQLSer...e-is-not-valid .

Here's the full comment:

Unfortunately I am not able to apply your solution. Indeed I couldn't wait
49 days with that project thus I had to ask the assistance of Microsoft
Product Support Services. They discovered the bugs and here is the
workaround which allowed me to install SQL Server 2008 x64:
1. If Visual Studio 2008 is already installed, then SP1 must also be
installed before starting the installation of SQL 2008
2. Do not try to install previous versions of MS SQL Server others than
SQL Server 2005 RTM
3. Do not install RC/Beta versions of SQL Server 2008 or Visual Studio
2010 Beta/CTP
4. However, if such attempt has been made that version should be
uninstalled
5. Because Uninstall does not remove all that should be removed, the
following must be done:
a. Run \x64\setup\x64\SQLSysClrTypes.msi to uninstall the CLR Types (this
step might be optional, depends if Visual Studio 2010 was installed)
b. Remove the following entries from the Registry
i.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Installer\UserData\S-1-518\
Components\0D1F366D0FE0E404F8C15EE4F1C15094]
ii.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\Curr entVersion\Installer\UserData\S-1-5-18\
Components\C90BFAC020D87EA46811C836AD3C507F]
Thanks,
Dan

On my machine, only the first mentionned registry was there; not the second
one.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Blog/web site: http://coding-paparazzi.sylvainlafontaine.com
Independent consultant and remote programming for Access and SQL-Server
(French)


"sliddicoat" <sliddicoat (AT) discussions (DOT) microsoft.com> wrote