I’m sure many of you would have seen this issue when running SQL 2008/2008 R2/2012 setup on a new server. The setup will proceed to install Setup support files, the window will disappear but, strangely enough, the next window never shows up.

Here’s what you need to do:

  1. Click on start->run and type %temp% and press enter (basically, go to the temp folder)
  2. Here, look for SQLSetup.log and SQLSetup_1.log. Open the SQLSetup_1.log file. In there, check for the following messages:
    04/16/2012 17:16:47.950 Error: Failed to launch process
    04/16/2012 17:16:47.952 Error: Failed to launch local setup100.exe: 0x80070003

Typically, you get this error only in SQL 2008, SQL 2008 R2 and SQL 2012. The steps are slightly different for all 3, and I’ve tried to outline them here:

SQL Server 2008

1. Save the following in a .reg file and merge to populate the registry:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
"BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\"

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
"PatchLevel"="10.0.1600.22"

2. Next, copy the following files and folders from the media to the specified destinations:

    File/Folder in media

    Destination

    X64/X86 (depending on what architecture you want to install)

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release

    Setup.exe

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release

    Setup.rll

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Release\Resources\1033\

    SQL Server 2008 R2

    1. Save the following in a .reg file and merge to populate the registry:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap]
    "BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\100\\Setup Bootstrap\\"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\Bootstrap\Setup]
    "PatchLevel"="10.50.1600.00"

    2. Next, copy the following files and folders from the media to the specified destinations:

    File/Folder in media

    Destination

    X64/X86 folder (depending on what architecture you want to install)

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

    Setup.exe

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

    Resources folder

    C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\SQLServer2008R2

    Next, re-run the setup, and it should proceed beyond the point of error this time.

    SQL Server 2012

    1. Save the following in a .reg file and merge to populate the registry:

    Windows Registry Editor Version 5.00

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap]
    "BootstrapDir"="C:\\Program Files\\Microsoft SQL Server\\110\\Setup Bootstrap\\"

    [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\110\Bootstrap\Setup]
    "PatchLevel"="11.00.2100.60"

    2. Next, copy the following files and folders from the media to the specified destinations:

    File/Folder in media

    Destination

    X64/X86 folder (depending on what architecture you want to install)

    C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

    Setup.exe

    C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

    Resources folder

    C:\Program Files\Microsoft SQL Server\110\Setup Bootstrap\SQLServer2012

    Next, re-run the setup, and it should proceed beyond the point of error this time.

    As always, comments/suggestions/feedback are welcome and solicited.