Recently, I have a developer asked me to help to install management studio on her laptop. Sure! How hard could it be? So I start as usual and installing the SSMS from the installation disc image.
In the middle of the installation, it stops. With the following error:
Given that, who on earth would be still using Visual Studio 2008!? Everyone moved forward to Visual Studio 2010 already. Something does make sense here... So, Yay!! It~~ is~~~ Google time!!
Did some research. This is, in fact, quite an old issue dated back to 2011 from most of the post I read. Note that most of the post reported that they haven't installed Visual Studio 2008 on their machine. Anyway, the solution is involved with registry key change, so make sure you have extract the registry for rollback purpose.
Firstly, you need to determine if you have a 32-bit or 64-bit OS. That will determine if you need to carry on with an additional step.
Next, let's check the following registry keys with the regedit. Make sure that the SP and SPIndex values are "1" and that the SPName is "SP1":
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
- HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033
Now, if you have a 64-bit OS, this is extra that you need to go further. Similar deal, make sure that the SP and SPIndex values are "1" and that the SPName is "SP1":
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
- HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033
After all of this, just restart the installation again and this time the installation should be able to be completed. To credit the solution, here is the URL for reference: SQL Server 2008 R2 Management Studio install fails telling me to install Visual Studio 2008 SP1!. Thanks, Eric!!
No comments:
Post a Comment