Welcome to MSDN Blogs Sign in | Join | Help

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.

Published Monday, February 02, 2009 1:02 PM by Heath Stewart

Comments

Thursday, February 05, 2009 1:10 PM by Jamie Cansdale

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

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.

Thursday, February 05, 2009 4:09 PM by Heath Stewart

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

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.

Tuesday, March 17, 2009 6:58 PM by Ken

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

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

Wednesday, March 18, 2009 6:53 PM by ggponti

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

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.

Saturday, March 21, 2009 12:05 PM by Phil

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

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.

New Comments to this post are disabled
 
Page view tracker