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.
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
Once you start installing this patch, below is what you would see.
If you have not cancelled the setup after seeing the message, you can use “Re-run” button to run the check again
And you are green!!
Now, go ahead with the setup and post a comment here if this helped.
Cheers,
Balmukund Lakhani
Twitter @blakhani
Bil said
Err – that info is in the SQL Server 2012 readme file.
Piyush said
Hello, I gave it a try and it worked without any issue. Instruction is simple and easy to follow.
thanks
Farid said
I actually didn’t know that there is a setup of visual studio 2010 SP1 in the media. THank you very much.
san said
thanks it work….
mall said
Thank you so much.
“Prior Visual Studio 2010 instances requiring update.” rule failed installing SQL Server 2012 « Edoardo Benussi said
[…] https://sqlserver-help.com/2011/12/08/help-getting-visual-studio-service-pack-error-while-installing-… […]
madu said
I done it several times,But error is same
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.
Rashed said
Thanks
Aleksei said
Thank you sir! The first option with downloading and installing SP1 worked for me!
Danno said
Thank you, this worked for me too!
phani said
thanks it worked for me (Y)
anastris said
thanks you much its really help me solve this problem.. wonderful
anastris said
thanks you very much its really help me solve this problem.. wonderful
raval said
Thank you very much… It resolved the issue… Too good….
jayeshsorathia said
Thanks, It’s worked.
Perfect solution.
donny said
Thank you very much
janmejaya behera said
Thank u so much it works………
its resolve the issue….
peyman said
thank you……
Installing SQL Sserver 2012 – Error: Prior Visual Studio 2010 instances requiring update | Just A Little Sharing said
[…] had this issue too, after following this guide, it was simply 1 additional patch that was required to get past […]
Thanh Tâm said
Thanks so much!
Senthil said
It worked, Great.. Thanks for your solution…
hosein said
Great,Worked,Easy and Helpful.
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
Kennedy Kinyanjui said
Thanks!
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.
Dustin Dale Aquino said
Thank you sir!
Hend said
That works very well
Thanks a lot
praveen vara prasad said
thank you soo much….
this is working 100%…
Isaac Kariuki said
This worked! Asante sana (Thanks alot!) blakhani
blakhani said
My pleasure.
Tomasz Orlowski said
Thanks, it worked.
blakhani said
Great. Thanks Tomasz!
Stephenraj said
Thank u so much…its working
blakhani said
Thanks a lot!
sam said
This should work
Muhammad Azeem said
Its not working
Pranay gupta said
THANK U SO MUCH REALLY HELPED
dawan said
Thank u 🙂 🙂
Lorenzo Inofre said
Thanks for this… ^_^
blakhani said
Welcome
yatokamiblog said
I tried it several times and it is not still working….
Raghunath said
This works for 2014 sql express edition as well.
Danilo said
Grazie, è stato davvero utile.
chirag said
Thanks dear finally sql server 2014 installation success.
Naomi said
i find the link for service pack 1, but the download file in no longer available.Where can i find it?
Kevin said
Thanks! Worked like a charm. I appreciate you sharing your experience to the development community.
Joe said
THANK YOU!! THANK YOU!! THANK YOU!! THANK YOU!!
Microsoft took away the download file! The link in the error is now bad. I have an MSDN subscription and you cannot get ( a valid ) SP1 for VS2010. The file in the folder did the trick!!
blakhani said
My pleasure. Out of curiosity, what was the SQL version you were trying to install?,
Sangamithra said
I tried installing SP1 by two ways(installing Online and from Setup Media) you said. But nothing proved fruitful.
Please help me!!!
Hari said
Thanks. It saved lot of time
Will López said
Thanks, so much!!
JOHNATTAN said
Thanks so much, It help me so much, I appreciate it!!!
Banu said
while installing the service pack 1 ,i came up with an error which says,KB2565057 does not apply, or is blocked by another condition on your computer.can anyone help me to resolve this…
blakhani said
Best way to get help on production issues is to contact support. You can also try forums to get better help than comments on blog.