Feature Changes in Visual Studio 2008 SP1 may prompt for SQLSysClrTypes.msi

After installing Visual Studio 2008 Service Pack 1, adding or removing features from Visual Studio may prompt for the file SQLSysClrTypes.msi with the following text:

Setup is looking for file SQLSysClrTypes.msi.
Please insert Microsoft Visual Studio Team System 2008 Team Suite – ENU disk 1 now.

The text will read differently depending if you have Visual Studio 2008 Professional Edition or another edition or language installed.

Workaround

SQLSysClrTypes.msi is a product package installed with VS2008 SP1. To satisfied this prompt you’ll need to obtain that file again.

  1. Download a complete layout of VS2008 SP1 if you haven’t already.
  2. Open the directory were you copied VS2008 SP1.
  3. Right click on SQLSysClrTypes.msi and select Copy.
  4. Open an Explorer window (ex: Windows key + E) and browse to the directory where you installed Visual Studio 2008. By default this is “C:\Program Files\Microsoft Visual Studio 9.0” where C:\ is your system drive.
  5. Double click on the folder that corresponds to the name of the product you installed (ex: “Microsoft Visual Studio Team System 2008 Team Suite – ENU”).
  6. Right click on empty space in the window, click New, then Folder, and type “wcu” (without quotes).
  7. Double click that new “wcu” folder to open it.
  8. Right click on empty space in the window, click New, then Folder, and type “smo” (without quotes).
  9. Double click that new “smo” folder to open it.
  10. Right click on empty space in the window and click Paste.
  11. In the dialog prompt requesting SQLSysClrTypes.msi, click the Browse button.
  12. Expand folders to select the directory you opened in step 5 and click the OK button. Do not select the “wcu\smo” directory you created.
  13. Click the OK button on the dialog prompt.

On 64-bit machines you will always see this prompt when adding or removing features so it is recommended you keep this file for future use. If you are a network administrator or have the installation source copied to your hard drive, you can also create this directory in the root of the original installation source directory and the setup executable will automatically find SQLSysClrTypes.msi.