Thushan Fernando Uncut

thanks this worked a treat!

Who the h*ll wants to install mssql2008 without the managementstudio? Thats like playing tennis without a ball d!ckwad.

I was able to get past this by uninstalling Visual C# 2008 Express, which I had installed befroe the full version of 2008 with SP1. I also uninstalled anything that said sql 2008 in the “Add/Remove programs” dialog after the install failed the first time. After doing that cleanup, everything worked!!!! YAY!

The other solution that worked for one of my colleagues was to uninstalled VS2008 completely, installed SQL 2008, then install VS2008 with SP1 again. That wasn’t a viable option for me. I was determined to find a way around it. Good luck!

I left the “management studio” out as it was the only way to install SQL 2008 on Vista. But how do you manage SQL 2008 without it? I have Visual Studio Version 9.0.21022.8 RTM. See my tweets about this at http://twitter.com/tunis

It works sweet..

One of the things in this installation, that I thought we had gotten past as an industry, is the 17 questions and password entries and 10 minutes of time that it goes through before checking weather it can be installed. And then the check erroneously fails. That is frustrating now that I have tried it 32 times.

Your fix worked, BTW, but now how to install the management?

@Justin Greenwood
I followed Justin’s fix except I did not uninstall any SQL server 2008 files. It allowed me to proceed with the install of SQL 2008 + management software

I unistalled VS 2008 web express and that worked for me as well. Iwas able to add the management studio and business intellegence components.
Thanks

worked for me selecting only the database engine. We can always use the server explorer in vs 2008. I agree its a lot pants and Im sure a lot of devs will say “screw this” and go back to sql 2005.

Found a solution:
- If you have Visual Studio 2008 installed, make sure Visual Studio 2008 SP1 and .Net 3.5 framework SP1 is also installed.
- Uninstall other versions of visual studio: I had professional and express installed on my computer, it only worked when I uninstalled the express 2008.
- Try installing SQL Server 2008 again, this time with the Management Studio checked

Microsoft also posted a solution… but I didn’t follow its instructions because it involved a lot of uninstalling/reinstalling.
If you’re still interested, see: http://support.microsoft.com/kb/956139

Yes !!
- Uninstalling VS C# 2008 express finally did the trick. Thanks a lot!

This error message has been bugging me for months.

An even simpler solution that I have found, skip that particular validation check altogether. There is an undocumented switch called /SkipRules that can be used when running the Setup.exe from a command prompt. Open up a command prompt and go to the directory where you have your SQL2008 install files and run the below:

Setup /ACTION=install /SkipRules=VSShellInstalledRule

This will run the installation but skipping the rule that checks for previous versions of VS2008 allowing you to install the Management Studio Software which is what I needed.

Enjoy !!
Paul.

thanks Paul..

Setup /ACTION=install /SkipRules=VSShellInstalledRule RebootRequiredCheck

this worked!!

alright! paul’s fix is great! I didn’t need to un-install/re-install my Visual Studio to get around this. that would have been sad *tear* but thanx to you, i don’t need to worry about that anymore =) tnx paul!!

Paul is King of SQL Setup, long live the King!

I’m glad to see that my tip has helped a few people

Paul,
You are the bomb. Days of trying to get this to work by uninstalling and reinstalling….the only thing that worked for me was your suggestion. Thanks so much!

Thanks Paul,
Your solution works for me.
I was trying from last 2 days … insttalling and uninstalling…..

But finally ur solkution works .

Thanks,
SAGA

Paul, nice get !
Indeed after observing the setup process, the first screen interface when clicked in some action, actually calls for setup with some parameters, removing the tools eventuly called for setup with these /skipprules param. What was the program you used to track this call, Sys internals processes ?

@Paul
Paul, You made my week ! thanks a lot from Ukraine

Paul thak u sooo much u saved my day!!! =)

great Paul.. it worked n solved my problem.
thanks a lot

I have VS2008 Team System SP1 installed, and it was installed before even trying to install SQL Server 2008 on Windows 7 32-bit RC. Paul’s solution got me past the error, but I just got another pop-up as SQL Server was installing claiming that another VS2008 was installed that needed to be upgraded to SP1 beforehand. So bizarre…

Thanks Paul, u are my hero!!

Another succes story for Paul´s solution! I spent a couple of days before Setup /ACTION=install /SkipRules=VSShellInstalledRule
Thanks Paul

yes, very helpful.. thanks

@Paul
———————
GREAT NOTE! I still have some hair left thanks to you Paul!

RK :Paul, nice get !Indeed after observing the setup process, the first screen interface when clicked in some action, actually calls for setup with some parameters, removing the tools eventuly called for setup with these /skipprules param. What was the program you used to track this call, Sys internals processes ?

Nope, I just read about the install switches someplace on the MS site. A bit of digging in the config files in the install itself I found the undocumented switch mentioned. A bit of luck but hey it works and it’s great to see my tip has helped so many since I posted it originally back in April !

Paul.

@Paul

Thanks for the solution Paul, but it resulted in an error at later stage and SQL server setup didnt complete successfully. Only some components installed, Management Studio and other required components were not installed. So whats the ultimate benefit of this solution.

Naveen Goel :@Paul
Thanks for the solution Paul, but it resulted in an error at later stage and SQL server setup didnt complete successfully. Only some components installed, Management Studio and other required components were not installed. So whats the ultimate benefit of this solution.

Well it worked for me and countless others so I’m not sure what to suggest. You must have another issue that is causing problems with your install.

Worked for me. Good tip after several hours of fruitless uninstalling and reinstalling

Thanks Paul for hack, but unfortunately it did not work for me:(
When it comes to “Feature Selection step” the features tree only populated with the root nodes, but no children (i.e. no features!). That is, when if click “Next” I got the error: “To continue one or more feature must be selected”!
any idea?

Paul’s solution didn’t work for me either. I had VS2008 Team Explorer installed. Uninstalling Team Explorer and Shell (integration mode) allowed SS2k8′s tools to be installed.

@Paul

Thanks Paul!!!

@Paul
Awesome! Thanks Paul I really wished I would have found this page YESTERDAY I was just about to call it quits.

Thanks Paul, it works for me dude

thaks Paul. it waste my time, and it’s installing now. ^_^

@Toshinaka

Have the same issue on W7 64 U, have you found solution for this yet?

Thanks Paul! You’re a hero

Paul thak u soooooooooooooo much

TITLE: SQL Server Setup failure.
SQL Server Setup has encountered the following error:

The specified value for setting ‘WORKFLOW’ is invalid. The expected values are:

None
RemovePatch
Uninstall
Install
Upgrade
Patch
Repair
LandingPage
ClusterReport
RunRules
PrepareFailoverCluster
CompleteFailoverCluster
InstallFailoverCluster
RemoveNode
AddNode
EditionUpgrade
Bootstrap
ComponentUpdate
Help
RebuildDatabase
RunDiscovery

Error code 0x84B40002.

——————————
BUTTONS:

OK
——————————
Well, Anyone got this error with Paul’s way?

Hello, I am trying to do Paul’s code in but is giving me this error
Does anyone knows what to do if you get the following error?
TITLE: SQL Server Setup failure.
——————————

SQL Server Setup has encountered the following error:

The specified value for setting ‘WORKFLOW’ is invalid. The expected values are:

None
RemovePatch
Uninstall
Install
Upgrade
Patch
Repair
LandingPage
ClusterReport
RunRules
PrepareFailoverCluster
CompleteFailoverCluster
InstallFailoverCluster
RemoveNode
AddNode
EditionUpgrade
Bootstrap
ComponentUpdate
Help
RebuildDatabase
RunDiscovery

Error code 0x84B40002.

——————————
BUTTONS:

OK
——————————

Thanks Paul u made my day

@Rafferty Uy
Your solution was the key to solve my problem, thank you. Now I have all under control with my Visual Studio 2010. I used the SQLEXPRADV_x86_ENU.exe the setup the management system and didn’t selected the web reports. After that all went great. Thank you

wow, you are absolutely great Paul….
finally it’s work very well..
thanks paul..

This will save time ..plz follow steps

Error:

Installing SQL Server 2008 DE 64bit on Windows 7 Pro 64bit Problem: Previous release of VS 2008 exists.
its got failed Upgrade to SP1 required.
I already had VS 2008 Pro installed with SP1 still I would get this error. Uninstalling everything VS might have resolved the issue but would have resulted in waste of time.

solution:

Is to edit registry key HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0 and update the values to 1 for SP and SPIndex. This key does not get updated during the SP1 installation. Ditto for
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0\IDE\1033 and for
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VS\Servicing\9.0\VSTS\1033 SP =1, SPIndex = 1 and SPName = “SP1″ without the quotes. After doing this I clicked re-run and the check passed. So uninstallation of VS 2008 required neither do you have to start the SQL Server setup all over again. Simple elegant solution. Please let me know guys how it went for you.

Thanks paul. i was breaking my head over this for a week.

rameshnagineni !

Thank you! For those of us who actually have VS2008 SP1 installed, and the SQL Installer as per usual complains, yours is the real solution!

I remembered having used a similar solution before but this time i was trying to install on an 64bit OS and didn’t realise the Wow6432Node part that is also needed.