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

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

  • Comments 9

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.

Leave a Comment
  • Please add 8 and 2 and type the answer here:
  • Post
  • To get this to work I also needed to create a folder called 'Setup' on my desktop. I copied the 'Setup\setup.sdb' file from the original VS 2008 DVD into this folder. Only after doing this would the prompt accept my 'Desktop' folder and continue the install.

    Regards,

    Jamie.

  • Jamie, thank you. Originally the instructions were to put this under the installation cache directory which was a bit more to explain, so to simplify instructions I thought referencing the Desktop was easier. Since the instructions are incomplete, however, I'll put up the original instructions such that Setup\setup.sdb does not need to be copied.

  • Thanks for posting this. You saved me from a full reinstall.

  • I was adding the Visual Web Developper feature, and I couldn't get to install it because of the missing SQLSysClrTypes.msi on a Windows Vista 64-bit machine.

    Your suggestion didn't help, but after cancelling the setup, and manually installing SQLSysClrTypes.msi from the SP1 I was able to add the feature.

  • SQLSysClrTypes.msi fails to download every time I try to run the sp1 installer. I copied the URL from the log and tried to download it manually in my web browser (Opera) and it gets to 260k or 261k and stops every time, but the download is 1.5M.

  • it needs this dir:

    temp\

    temp\setup\setup.sdb   from 2008 dvd

    temp\wcu\

    temp\wcu\smo\SQLSysClrTypes.msi download from microsoft

    select the temp folder in that dialog. it works!

  • @ahgan -

    BINGO!  That is all I needed, thanks!

  • Thank you for sharing the solution!

  • Thanks! It works even with "Microsoft Visual Studio 2008 Professional Edition - ENU". I copied the file from the "Visual Studio 2008 Service Pack 1" MSDN DVD.

Page 1 of 1 (9 items)