Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

Help: Getting Visual Studio Service Pack Error while installing SQL Server 2012 Release Candidate 0 (RC0)

Posted by blakhani on December 8, 2011


To make my AlwaysOn demo up-to-date with latest release, I uninstalled SQL Server 2012 (a.k.a. Denali) CTP3 from my machine(s) and and started to install SQL Server 2012 RC0.

Setup started fine and later after doing feature selection and then I received this error. Interestingly I didn’t receive error another machine both were made from same image.

01_VSErrorBlog

Here is the text of the error message for better search.

—————————
Rule Check Result
—————————
Rule "Prior Visual Studio 2010 instances requiring update." failed.

This computer has an installation of Visual Studio 2010 that requires a Service Pack 1 update that is needed for a successful installation of SQL Server based on your feature selection. To continue, install the required Visual Studio 2010 Service Pack 1 from SQL Server media or from http://go.microsoft.com/fwlink/?LinkID=220649.
—————————
OK  
—————————

one might ask, I don’t have Visual Studio product installed, why do I get this error. Well, SQL Server Tools (SSMS, BIDS) uses Visual Studio Shell. But, I thought that why setup didn’t do this check on earlier screens. Later, looking at the code I realized that we do this check if we install components which need Visual Studio Shell (like SQL Server Management Studio)

Here is the public proof of my theory from setup logs. You will also understand what all we check over here.

<Detail.txt>
(07) 2011-12-07 22:46:51 Slp: Loading rule: DEV10RTMDetected
(07) 2011-12-07 22:46:51 Slp: Creating rule target object: Microsoft.SqlServer.Configuration.SetupExtension.DetectInstalledProductsFacet
(07) 2011-12-07 22:46:51 Slp: Rule applied features  : BIDS;SSMS

(12) 2011-12-07 22:46:51 Slp: Init rule target object: Microsoft.SqlServer.Configuration.SetupExtension.DetectInstalledProductsFacet
(12) 2011-12-07 22:46:51 Slp: Package ID VSIntShellRTM_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSIsoShellRTM_Cpu32: Installed – Version: 10.0.30319
(12) 2011-12-07 22:46:51 Slp: Package ID VBExpress_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VCSExpress_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VCExpress_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID WPExpress_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSPremium_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSPro_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSTE_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSUltimate_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSLabAgent_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSTestAgent_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VSTestController_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: Package ID VWDExpress_Cpu32: NotInstalled
(12) 2011-12-07 22:46:51 Slp: The package ‘VSIsoShellRTM_Cpu32’ is installed.
(12) 2011-12-07 22:46:51 Slp: Rule ‘DEV10RTMDetected’ detection result: AreAnyProductsInstalled= True
(12) 2011-12-07 22:46:51 Slp: Evaluating rule        : DEV10RTMDetected
(12) 2011-12-07 22:46:51 Slp: Rule running on machine: ALWAYSON-SRV4
(12) 2011-12-07 22:46:51 Slp: Rule evaluation done   : Failed
(12) 2011-12-07 22:46:51 Slp: Rule evaluation message: This computer has an installation of Visual Studio 2010 that requires a Service Pack 1 update that is needed for a successful installation of SQL Server based on your feature selection. To continue, install the required Visual Studio 2010 Service Pack 1 from SQL Server media or from http://go.microsoft.com/fwlink/?LinkID=220649.
</Detail.txt>

DEV10RTMDetected is the rule name and it would fire only if you select BIDS and/or SSMS, we would fire the rule and block installation on failure. Now why it did not come on another machine because I didn’t select tools there.

Okay, now you may ask – what I need to do now? Well, have a look at error message. It tells you the action needed. So here are the solutions.

  • Go to http://go.microsoft.com/fwlink/?LinkID=220649 and download SP1. As per note on the link

    ”This web installer downloads and installs Visual Studio 2010 Service Pack 1. An Internet connection is required during installation”

  • Other better way is to use the setup media. Yes, you read is correctly, SQL Server 2012 RC0 setup media. Below is the location of the package to install Visual Studio 2010 SP1

 
02_VSErrorBlog

Once you start installing this patch, below is what you would see.

03_VSErrorBlog

If you have not cancelled the setup after seeing the message, you can use “Re-run” button to run the check again

04_VSErrorBlog 

And you are green!!

05_VSErrorBlog

Now, go ahead with the setup and post a comment here if this helped.

Cheers,
Balmukund Lakhani
Twitter @blakhani

Advertisements

44 Responses to “Help: Getting Visual Studio Service Pack Error while installing SQL Server 2012 Release Candidate 0 (RC0)”

  1. Bil said

    Err – that info is in the SQL Server 2012 readme file.

  2. Piyush said

    Hello, I gave it a try and it worked without any issue. Instruction is simple and easy to follow.
    thanks

  3. Farid said

    I actually didn’t know that there is a setup of visual studio 2010 SP1 in the media. THank you very much.

  4. san said

    thanks it work….

  5. mall said

    Thank you so much.

  6. […] https://sqlserver-help.com/2011/12/08/help-getting-visual-studio-service-pack-error-while-installing-… […]

  7. madu said

    I done it several times,But error is same

  8. exandy said

    this is one big mess, im a developer with vs 2010 sp1 already installed. why do i see this message.
    Your fix doesnt work, i reapply vs2010 sp1 and it just starts to roll back the installation and fail. (because i guess its already installed)

    can not remove vs 2010 sp1 ive had problems before when doing this (just read the info before you try)

    this workaround doesnt work and no fixes out there as far as i can see.

    well done ms for wasting my money and my time.

  9. Rashed said

    Thanks

  10. Aleksei said

    Thank you sir! The first option with downloading and installing SP1 worked for me!

  11. Danno said

    Thank you, this worked for me too!

  12. phani said

    thanks it worked for me (Y)

  13. anastris said

    thanks you much its really help me solve this problem.. wonderful

  14. anastris said

    thanks you very much its really help me solve this problem.. wonderful

  15. raval said

    Thank you very much… It resolved the issue… Too good….

  16. jayeshsorathia said

    Thanks, It’s worked.
    Perfect solution.

  17. donny said

    Thank you very much

  18. janmejaya behera said

    Thank u so much it works………
    its resolve the issue….

  19. peyman said

    thank you……

  20. […] had this issue too, after following this guide, it was simply 1 additional patch that was required to get past […]

  21. Thanh Tâm said

    Thanks so much!

  22. Senthil said

    It worked, Great.. Thanks for your solution…

  23. hosein said

    Great,Worked,Easy and Helpful.

  24. erik said

    this doesn’t work for me. i tried to install that KB983509 like 10 times, restart my computer even more than 10 times and i still can’t pass through that prior error. all i need is just the management studio for this sql server. i forgot to check while installing it. please give me solution. thx before

  25. Thanks!

  26. Petra gravatt said

    I blog frequently and I seriously appreciate your content. Your article has really peaked my interest. I’m going to book mark your
    website and keep checking for new details about once a week. I subscribed to your Feed as well.

  27. Thank you sir!

  28. Hend said

    That works very well
    Thanks a lot

  29. praveen vara prasad said

    thank you soo much….
    this is working 100%…

  30. Isaac Kariuki said

    This worked! Asante sana (Thanks alot!) blakhani

  31. Tomasz Orlowski said

    Thanks, it worked.

  32. Stephenraj said

    Thank u so much…its working

  33. sam said

    This should work

  34. Muhammad Azeem said

    Its not working

  35. Pranay gupta said

    THANK U SO MUCH REALLY HELPED

  36. dawan said

    Thank u 🙂 🙂

  37. Lorenzo Inofre said

    Thanks for this… ^_^

  38. I tried it several times and it is not still working….

  39. Raghunath said

    This works for 2014 sql express edition as well.

  40. Danilo said

    Grazie, è stato davvero utile.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: