none
SQL Server 2008 R2 Management Studio install fails telling me to install Visual Studio 2008 SP1!

    Question

  • Hi,

    I am getting the following error when trying to install SQL Server 2008 R2 Management Studio (SQLManagementStudio_x86_ENU.exe or SQLManagementStudio_x64_ENU.exe) on a new Toshiba Portege R830-10R:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    I have all Windows Updates installed on this machine and I DO NOT have VS 2008 installed on this computer (VS2008 was never installed on this computer), but VS 2010 SP1 with .Net Framework 4.0 SP1!

    I have sent all day trying to install either ones of the above .exe, but always get the same error message.

    I have checked the registry and see that I do not have a  HKLM\SOFTWARE\Microsoft\DevDiv\VS key but only a HKLM\SOFTWARE\Microsoft\DevDiv\VC key (probably since I configured VS1010 for C#).  The HKLM\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0 contains SP = 1 and SPIndex = 1.

    Please help.
    Thanks.

    Eric

    Tuesday, July 05, 2011 11:45 PM

Answers

  • Hi Chaitanya,
    Hi Jeff,

    For the sake of those who might run into the same problem as the one described in this post, I have solved the problem.
    Here is how it goes:

    If you have a 64-bits computer, you need to check not only the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033

    and ensure that the SP and SPIndex values are 1 and that the SPName is SP1 (I had done that and the keys were ok but I was still having the problem), but you must also chek the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

    and also ensure that the SP and SPIndex values are 1 and that the SPName is SP1, which I had not done!  The SP and SPIndex values were 0 and the SPName was RTM.  I changes them to 1 and SP1 respectively.  Note that it is a bit strange since I had never installed any version of VS 2008 on this machine!

    I could then install SQL Server 2008 R2 Management Studio with no problem!

    Note that I installed it from Microsoft Web Platform and that, after updating the above registry keys, I had to close Web Platform and reload it before I could indeed install SQL Server 2008 R2 Management Studio.

    How did I find these other registry keys?

    When first trying to install Management Studio using the SQLManagementStudio_x86_ENU.exe installer, I noted the action that was displayed at the time the error message about VS 2008 SP1 got displayed.  The action was:

    Install_trin_aide_Cpu32_Action:  CA_BlockOnVSSP0_x86

    I then googled on CA_BlockOnVSSP0_x86 and found only one site: 
    http://blogs.msdn.com/b/guil/archive/2008/12/14/sql-server-2008-installation-dependency-problems-with-visual-studio-2008-sp1.aspx
    where I read about those other registry keys.

    Hope this helps.

    Problem solved.
    Thanks for your help.

    Eric

    Wednesday, July 06, 2011 11:18 PM

All replies

  • Are you sure it states Visual Studio 2000 and not SQL Server 2008?

    For Windows 7 and Windows Server 2008 R2, the install process displays the “Program Compatibility Assistant” dialog indicating that you must apply SQL Server 2008 Service Pack 1 or later. Select the option to “Run Program” to continue. Future releases of Microsoft SQL Server 2008 R2 Management Studio Express will not have this problem.


    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    Wednesday, July 06, 2011 1:40 AM
  • From your Add/Remove programs of Control Panel, can you quickly check if there are any VS2008 components installed? Am wondering just in-case if they are blocking this installation.

    In addition to this, check the article: http://support.microsoft.com/kb/956139 [Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed]

     


    Chaitanya( Twitter | Blogs )

    Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
    This posting is provided "AS IS" with no warranties, and confers no rights.

    The next CTP for SQL Server Code Name "Denali" is coming soon. Sign up now to be notified of the next CTP release.
    Wednesday, July 06, 2011 4:13 AM
  • Hi Jeff,

    First, FYI, I am running Windows 7 Pro 64-bits SP1 on this machine.

    Yes, it states Visual Studio 2008.  The error message is the exact one I mentioned in my earlier post and which I repeat here:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1. Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    I also failed to mention that, after I got the above error which does not prevent SQL Server 2008 R2 to finish installing (it just prevents SQL Management Studio to get installed), the setup program finally bombs with:

    SQL Server 2008 R2 Setup has stopped working.

    Again, the computer is a brand new computer received a few days ago, on which I just installed Visual Studio 2010 SP1.

                       ***

    Answering to Chaitanya below:

    First I never installed SQL Server 2008 Prerelease on this machine. Again it is a brand new computer.
    I had looked at Control Panel/Program and Features and there is no Microsoft Visual Studio 2008 there, only Microsoft Visual Studio 2010.
    However there are some entries concerning Micorsoft Visual C++ such as:

    Microsoft Visual C++ 2005 Redistributable
    Microsoft Visual C++ 2008 Redistributable - x64
    Microsoft Visual C++ 2008 Redistributable - x86
    Microsoft Visual C++ 2010 Redistributable - x64 DesignTime
    Microsoft Visual C++ 2010 Redistributable - x64 Runtime
    Microsoft Visual C++ 2010 Redistributable - x86 Runtime

    Could the Microsoft Visual C++ 2005 or 2008 Redistributable be cause of the problem?

    Note that I have:

    Visual Studio 2008 Shell Isolated Mode Redsitributable Package

    which is because I installed it to try solving the problem.  I have now uninstalled it and the problem remains.

    Note that I tried to run both of the SQLManagementStudio_x86_ENU.exe or SQLManagementStudio_x64_ENU.exe on my machine so maybe this has created some problems.

    Also note that I tried to install SQL Management Studio AFTER having installed VS 2010, not before.

    Also note that I tried SQL Server from Visual Studio 2010 using Server Explorer and it seems to work pretty fine.  It is just the SQL Server Management Studio which refuses to get installed.

    Do you suggest that I uninstall everything, i.e. all SQL Server 2008 R2 entries, all VS2010 entries, etc. then start by installing SQL Server 2008 R2 Management Studio, then only reinstall Visual Studio 2010?  (note that I would prefer avoid having to lose all the time this would require, if possible).

    Is there a way to force the SQL Server Management Studio setup to skip the VS 2008 SP1 check?

    Do you need any other info concerning my system?

    Any help would be much appreciated.  I have already lost a full day of work on trying to solve this problem.

    Thanks.

    Eric






    Wednesday, July 06, 2011 9:07 AM
  • I think one of these VS2008 components might be causing the problem to you. Can you go ahead and apply SP1 for those VC++ components. Here is the download: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=2092 [Microsoft Visual C++ 2008 SP1 Redistributable Package (x64)] and http://www.microsoft.com/download/en/details.aspx?id=5582 [Microsoft Visual C++ 2008 SP1 Redistributable Package (x86)]

    Uninstalling everything might not be the best solution, as its time taking. I would suggest you to try this, and check.

    Hope this helps..

     


    Chaitanya( Twitter | Blogs )

    Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
    This posting is provided "AS IS" with no warranties, and confers no rights.

    The next CTP for SQL Server Code Name "Denali" is coming soon. Sign up now to be notified of the next CTP release.
    Wednesday, July 06, 2011 9:25 AM
  • Hi Chaitanya,

    Thanks very much for your Email.

    I have done what you suggest, i.e. installing the VC++ SP1 for both x86 and x64, but that does not solve the problem.

    I then uninstalled all versions of Microsoft Visual C++ 2008 Redistributable and also Microsoft Visual C++ 2005 Redistributable I had on my computer and tried again to install SQLManagementStudio_x64_ENU.exe and still got the same error.

    I note that I had 3 versions of Microsoft Visual C++ Redistributable x86 and 2 of Microsoft Visual C++ Redistributable x64 on my machine though (before I uninstalled all of them): for x86 for example, I had:

    Microsoft Visual C++ 2008 Redistributable x86 - 9.0.30729.17
    Microsoft Visual C++ 2008 Redistributable x86 - 9.0.30729.4148
    Microsoft Visual C++ 2008 Redistributable x86 - 9.0.30729.6161

    After removing them and trying to install again SQL Server Management Studio which failed, I then reinstalled MS VC++ SP1 (both x86 and x64) using the link you sent me and curiously enough this installed:

    Microsoft Visual C++ 2008 Redistributable x86 - 9.0.30729.17
    Microsoft Visual C++ 2008 Redistributable x64 - 9.0.30729.17

    which seemed to be an earlier version than some of the ones I had on my computer before uninstalling them.

    I tried again to install SQL Server Management Studio x64 and got again the same error.

    All this is frustrating and time consuming.

    Do you or anyone else have any other idea on how to solve this problem?

    Eric

    Wednesday, July 06, 2011 12:50 PM
  • Hi Chaitanya,
    Hi Jeff,

    For the sake of those who might run into the same problem as the one described in this post, I have solved the problem.
    Here is how it goes:

    If you have a 64-bits computer, you need to check not only the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033

    and ensure that the SP and SPIndex values are 1 and that the SPName is SP1 (I had done that and the keys were ok but I was still having the problem), but you must also chek the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

    and also ensure that the SP and SPIndex values are 1 and that the SPName is SP1, which I had not done!  The SP and SPIndex values were 0 and the SPName was RTM.  I changes them to 1 and SP1 respectively.  Note that it is a bit strange since I had never installed any version of VS 2008 on this machine!

    I could then install SQL Server 2008 R2 Management Studio with no problem!

    Note that I installed it from Microsoft Web Platform and that, after updating the above registry keys, I had to close Web Platform and reload it before I could indeed install SQL Server 2008 R2 Management Studio.

    How did I find these other registry keys?

    When first trying to install Management Studio using the SQLManagementStudio_x86_ENU.exe installer, I noted the action that was displayed at the time the error message about VS 2008 SP1 got displayed.  The action was:

    Install_trin_aide_Cpu32_Action:  CA_BlockOnVSSP0_x86

    I then googled on CA_BlockOnVSSP0_x86 and found only one site: 
    http://blogs.msdn.com/b/guil/archive/2008/12/14/sql-server-2008-installation-dependency-problems-with-visual-studio-2008-sp1.aspx
    where I read about those other registry keys.

    Hope this helps.

    Problem solved.
    Thanks for your help.

    Eric

    Wednesday, July 06, 2011 11:18 PM
  • Hi Eric,

     

    I am glad to see your problem has been resolved and very appreciate for your update. Your solution will be benefit others who might suffer this issue, I will mark your reply as Answer and this could help other community to find the solution quickly.

     

    Thanks,
    Weilin Qiao


    Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
    Thursday, July 07, 2011 5:59 AM
    Moderator
  • Thank you very much Eric, that was a great help. I also have a Toshiba Pertege R830, and enountered the very same problem. I had eventually resorted to formatting the machine and starting completely from scratch in an attempt to solve it. This had no effect despite SQL server being the very first thing I installed. Toshiba must have some vs2008 components pre-installed for some reason.
    Saturday, August 27, 2011 12:59 AM
  • Eric, thank you very much for this information. I was fighting this problem for 2 hours tonight before I found your registry kludge and it worked perfect (at least as far as I can tell -- SQL Management Studio finally installed and appears to run correctly).

    I have a new Toshiba Satellite that I installed Visual Studio 2010 on, and no other version of Visual Studio -- of course there were already several VS redistributable packages already install on the new laptop.

    I wonder if this is something strange that Toshiba is doing?!?

    Sunday, August 28, 2011 4:41 AM
  • Eric,

    Also had same issue, and your solution solved it.

    Just like to had that this should be related to same sw installed by Toshiba: I had a setup similar to other users: Toshiba R830 brand new, W7 64 Pro + Office Pro 2010 + VS 2010 with SP1.

    Thanks,

    CC

     

     

     

     

     

    Saturday, October 15, 2011 8:32 PM
  • work wunderfull for me. thanks !
    Wednesday, October 26, 2011 1:29 PM
  • That worked for me too. Interestingly mine is an i7 Toshiba laptop. It appears their pre-installed OEM version must have some reference to Visual Studio 2008 runtime that is not the latest SP. Impossible to tell which.

    Anyway after a day wasted, I thank you for your efforts.

     

    Wednesday, November 02, 2011 6:40 AM
  • Wonderful solution. Worked for me. 

     

    Thanks a lot, saved my time. 

    Saturday, November 19, 2011 10:01 PM
  • Thanks Eric! Your solution worked perfectly for me. And yes, I too was facing this problem on my Toshiba laptop (Satellite Pro R850)
    • Proposed as answer by Mr. Wharty Thursday, January 26, 2012 9:15 AM
    Thursday, December 22, 2011 8:46 AM
  • ERIC,

    You saved the day man. This one helped me to kick the installation which was troubling from yesterday. Thanks a lot for the solution. Thanks Again!!!

     


    VVinayPrasad
    • Proposed as answer by Mr. Wharty Thursday, January 26, 2012 9:15 AM
    Monday, January 09, 2012 7:12 AM
  • Nice Solution. Worked for me also. Thanks a lot.
    Tuesday, January 24, 2012 6:40 PM
  • Hi,

    It looks like that you made upgradation on SQL Server R1.


    - Sekilha
    Thursday, January 26, 2012 9:11 AM
  • Hi,

    It looks like that you made upgradation on SQL Server R1.


    - Sekilha

    What is SQL Server R1?


    Jeff Wharton
    MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt), MCT, MCPD, MCITP, MCDBA
    Blog: Mr. Wharty's Ramblings
    MC ID: Microsoft Transcript

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
    Thursday, January 26, 2012 9:14 AM
  • Thanks a lot Eric ! My Problem has been resolved. 
    Sunday, January 29, 2012 2:32 PM
  • Thank you Eric,

     

    This solution work fine and was able to install the management studio succussfully.

     

    Thankyou

    Regards,

    Leon

    Tuesday, January 31, 2012 8:10 AM
  • This post was spot on for fixing the issue I was having with my SQL 2008 R2 Express installation.  It kept asking for SP1 for VS.  Great find!

    Problem Solved Thanks for your Help

    Rich 

    Thursday, March 22, 2012 6:53 PM
  • Thanks! My toshiba is a portege  r830 and this was the only way to get through this error. I have even removed the Visual Studio Macro editor that I found preinstalled in my os but didn't do the trick...
    Saturday, March 31, 2012 11:34 AM
  • Hi Chaitanya,
    Hi Jeff,

    For the sake of those who might run into the same problem as the one described in this post, I have solved the problem.
    Here is how it goes:

    If you have a 64-bits computer, you need to check not only the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\DevDiv\VC\Servicing\9.0\RED\1033

    and ensure that the SP and SPIndex values are 1 and that the SPName is SP1 (I had done that and the keys were ok but I was still having the problem), but you must also chek the following registry keys:

    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\DevDiv\VS\Servicing\9.0\VSR\1033

    and also ensure that the SP and SPIndex values are 1 and that the SPName is SP1, which I had not done!  The SP and SPIndex values were 0 and the SPName was RTM.  I changes them to 1 and SP1 respectively.  Note that it is a bit strange since I had never installed any version of VS 2008 on this machine!

    I could then install SQL Server 2008 R2 Management Studio with no problem!

    Note that I installed it from Microsoft Web Platform and that, after updating the above registry keys, I had to close Web Platform and reload it before I could indeed install SQL Server 2008 R2 Management Studio.

    How did I find these other registry keys?

    When first trying to install Management Studio using the SQLManagementStudio_x86_ENU.exe installer, I noted the action that was displayed at the time the error message about VS 2008 SP1 got displayed.  The action was:

    Install_trin_aide_Cpu32_Action:  CA_BlockOnVSSP0_x86

    I then googled on CA_BlockOnVSSP0_x86 and found only one site: 
    http://blogs.msdn.com/b/guil/archive/2008/12/14/sql-server-2008-installation-dependency-problems-with-visual-studio-2008-sp1.aspx
    where I read about those other registry keys.

    Hope this helps.

    Problem solved.
    Thanks for your help.

    Eric

    Thanks a million Eric, Problem solved.

    Thanks

    Divas


    Sunday, May 06, 2012 4:47 PM
  • Thanks Eric, worked like a bomb.

    Interestingly, I notice that everyone that has given their brand of PC is using a Toshiba - I had the problem on a Toshiba as well...

    Garth

    Thursday, June 07, 2012 7:25 PM
  • Hi eric..Thanks ..It was really a nice explanation...My problem solved in just 2 mins..Thanks a lot ...
    Thursday, June 14, 2012 6:02 AM
  • Exactly what I needed too, thanks!
    Saturday, July 07, 2012 6:18 AM
  • Worked for Eric,geat

    Thanks

    Robin

    Tuesday, July 31, 2012 7:46 PM
  • Hi Ericmar

    Thanks for the answer.. Same problem here.. VS pro 2010 with sp1 and MSsql Server 2008 r1.. On a windows 7 64 bit machine

    Your Registry settings worked like a charm ..

    Answers like yours make MS products great ;)

    best regards

    Marcel

    Wednesday, August 08, 2012 9:25 AM
  • Hello... I changed all of the recommended entries for the Registry Editor and I still get this message:

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    or some times it says the compliler has stopped and I am missing an app data file.. I have been trying to download management studios for too long and can't figure this out. I am also on a brand new Toshiba laptop that has visual 2008, 2010 c ++ redistributable x86, x64 on it.. CAN ANYONE HELP ME?!!!!!

    Wednesday, October 24, 2012 2:52 AM
  • Hello... I changed all of the recommended entries for the Registry Editor and I still get this message:

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    or some times it says the compliler has stopped and I am missing an app data file.. I have been trying to download management studios for too long and can't figure this out. I am also on a brand new Toshiba laptop that has visual 2008, 2010 c ++ redistributable x86, x64 on it.. CAN ANYONE HELP ME?!!!!!

    Wednesday, October 24, 2012 2:54 AM
  • Hello... I changed all of the recommended entries for the Registry Editor and I still get this message:

    TITLE: SQL Server 2008 R2 Setup
    ------------------------------

    The following error has occurred:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    or some times it says the compliler has stopped and I am missing an app data file.. I have been trying to download management studios for too long and can't figure this out. I am also on a brand new Toshiba laptop that has visual 2008, 2010 c ++ redistributable x86, x64 on it.. CAN ANYONE HELP ME?!!!!!

    Wednesday, October 24, 2012 2:59 AM
  • Did you try re-installing Visual Studio 2008 Service pack 1

    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Wednesday, October 24, 2012 7:27 AM
    Moderator
  • Hello Ahmed, thank you for getting back to me. I tried to re install Visual Studio 2008 Service pack 1 and when I run it, it says Setup has detected that this computer does not meet the requirements to install this update. The following issues must be resolved before you can install Microsoft Visual 2008 SP1 software update.

    Installing Requirements:

    A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio(ENU) product family, and is not compatible with any Express edition. 

    These were all pre installed on my laptop:

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.6161

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.6161

     Microsoft Visual C ++ 2010 x64 Redistributable - 10.0.40219

     Microsoft Visual C ++ 2010 x86 Redistributable - 10.0.40219

     And any time I tried to run the SP1 for these all it was doing was repairing it...

     Do you think I should uninstall all of these and than try to install management studios?

    How important are any of these to have on my laptop? 

    Some times it says Compiler has stopped, what does this mean?

    Wednesday, October 24, 2012 7:28 PM
  • Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068054016
      Exit facility code:            1212
      Exit error code:               0
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2012-10-23 13:03:21
      End time:                      2012-10-23 13:05:33
      Requested action:              Install
      Log with failure:              C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20121023_130205\trin_aide_Cpu32_1.log
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.1600.1

    Machine Properties:
      Machine name:                  PARM-PC
      Machine processor count:       4
      OS version:                    Windows 7
      OS service pack:               Service Pack 1
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          32 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Edition   10.51.2500.0    No        

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       0
      Installation location:         C:\Users\parm\Downloads\SQL Server 2008 R2 Enterprise (x86, x64, ia64) - DVD (English)\x86\setup\
      Installation edition:          ENTERPRISE

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20121023_130205\ConfigurationFile.ini
      CUSOURCE:                      
      ENABLERANU:                    False
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SSMS,ADV_SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      IACCEPTSQLSERVERLICENSETERMS:  False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   C:\Program Files (x86)\Microsoft SQL Server\
      INSTANCEID:                    <empty>
      INSTANCENAME:                  <empty>
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                     
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          <empty>
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      UIMODE:                        Normal
      X86:                           True

      Configuration file:            C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20121023_130205\ConfigurationFile.ini

    Detailed results:
      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files (x86)\Microsoft SQL Server\100\Setup Bootstrap\Log\20121023_130205\SystemConfigurationCheck_Report.htm

    This is the log file the last time management studios failed.. I hope this information will help to solve my problem... 

    Wednesday, October 24, 2012 8:02 PM
  • Seems you are installing the 32 bit version ?

    can you try installing the 64 bit ?


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Wednesday, October 24, 2012 8:56 PM
    Moderator
  • Overall summary:
      Final result:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Exit code (Decimal):           -2068054016
      Exit facility code:            1212
      Exit error code:               0
      Exit message:                  SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL Server Setup.
      Start time:                    2012-10-24 16:56:22
      End time:                      2012-10-24 16:58:18
      Requested action:              Install
      Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121024_165515\trin_aide_Cpu32_1.log
      Exception help link:           http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=10.50.2500.0

    Machine Properties:
      Machine name:                  PARM-PC
      Machine processor count:       4
      OS version:                    Windows 7
      OS service pack:               Service Pack 1
      OS region:                     United States
      OS language:                   English (United States)
      OS architecture:               x64
      Process architecture:          64 Bit
      OS clustered:                  No

    Product features discovered:
      Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
      Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Database Engine Services                 1033                 Enterprise Edition   10.51.2500.0    No        

    Package properties:
      Description:                   SQL Server Database Services 2008 R2
      ProductName:                   SQL Server 2008 R2
      Type:                          RTM
      Version:                       10
      SPLevel:                       1
      Installation location:         C:\Users\parm\Downloads\SQL Server 2008 R2 Enterprise (x86, x64, ia64) - DVD (English)\x64\setup\
      Installation edition:          ENTERPRISE

    User Input Settings:
      ACTION:                        Install
      ADDCURRENTUSERASSQLADMIN:      False
      AGTSVCACCOUNT:                 <empty>
      AGTSVCPASSWORD:                *****
      AGTSVCSTARTUPTYPE:             Manual
      ASBACKUPDIR:                   Backup
      ASCOLLATION:                   Latin1_General_CI_AS
      ASCONFIGDIR:                   Config
      ASDATADIR:                     Data
      ASDOMAINGROUP:                 <empty>
      ASLOGDIR:                      Log
      ASPROVIDERMSOLAP:              1
      ASSVCACCOUNT:                  <empty>
      ASSVCPASSWORD:                 *****
      ASSVCSTARTUPTYPE:              Automatic
      ASSYSADMINACCOUNTS:            <empty>
      ASTEMPDIR:                     Temp
      BROWSERSVCSTARTUPTYPE:         Disabled
      CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121024_165515\ConfigurationFile.ini
      CUSOURCE:                      
      ENABLERANU:                    False
      ENU:                           True
      ERRORREPORTING:                False
      FARMACCOUNT:                   <empty>
      FARMADMINPORT:                 0
      FARMPASSWORD:                  *****
      FEATURES:                      SSMS,ADV_SSMS
      FILESTREAMLEVEL:               0
      FILESTREAMSHARENAME:           <empty>
      FTSVCACCOUNT:                  <empty>
      FTSVCPASSWORD:                 *****
      HELP:                          False
      INDICATEPROGRESS:              False
      INSTALLSHAREDDIR:              c:\Program Files\Microsoft SQL Server\
      INSTALLSHAREDWOWDIR:           C:\Program Files (x86)\Microsoft SQL Server\
      INSTALLSQLDATADIR:             <empty>
      INSTANCEDIR:                   c:\Program Files\Microsoft SQL Server
      INSTANCEID:                    MSSQLSERVER
      INSTANCENAME:                  MSSQLSERVER
      ISSVCACCOUNT:                  NT AUTHORITY\NetworkService
      ISSVCPASSWORD:                 *****
      ISSVCSTARTUPTYPE:              Automatic
      NPENABLED:                     0
      PASSPHRASE:                    *****
      PCUSOURCE:                     
      PID:                           *****
      QUIET:                         False
      QUIETSIMPLE:                   False
      ROLE:                          <empty>
      RSINSTALLMODE:                 FilesOnlyMode
      RSSVCACCOUNT:                  <empty>
      RSSVCPASSWORD:                 *****
      RSSVCSTARTUPTYPE:              Automatic
      SAPWD:                         *****
      SECURITYMODE:                  <empty>
      SQLBACKUPDIR:                  <empty>
      SQLCOLLATION:                  SQL_Latin1_General_CP1_CI_AS
      SQLSVCACCOUNT:                 <empty>
      SQLSVCPASSWORD:                *****
      SQLSVCSTARTUPTYPE:             Automatic
      SQLSYSADMINACCOUNTS:           <empty>
      SQLTEMPDBDIR:                  <empty>
      SQLTEMPDBLOGDIR:               <empty>
      SQLUSERDBDIR:                  <empty>
      SQLUSERDBLOGDIR:               <empty>
      SQMREPORTING:                  False
      TCPENABLED:                    0
      UIMODE:                        Normal
      X86:                           False

      Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121024_165515\ConfigurationFile.ini

    Detailed results:
      Feature:                       Management Tools - Complete
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

      Feature:                       Management Tools - Basic
      Status:                        Failed: see logs for details
      MSI status:                    Passed
      Configuration status:          Passed

    Rules with failures:

    Global rules:

    Scenario specific rules:

    Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20121024_165515\SystemConfigurationCheck_Report.htm

    I just tried to install the 64bit and it still says :

    The following error has occurred:

    Another version of Microsoft Visual Studio 2008 has been detected on this system that must be updated to SP1.  Please update all Visual Studio 2008 installations to SP1 level, by visiting Microsoft Update.

    and when I try to run the Visual Studio 2008 SP1 it says:

    Setup has detected that this computer does not meet the requirements to install this update. The following issues must be resolved before you can install Microsoft Visual 2008 SP1 software update.

    Installing Requirements:

    A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio(ENU) product family, and is not compatible with any Express edition. 

    Thursday, October 25, 2012 12:02 AM
  • What do you think I should do? Because I have never been this frustrated in my life. 
    Thursday, October 25, 2012 12:03 AM
  • These were all pre installed on my lap"border:none;font-family:'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;margin-outline:0px;padding-right:0px;padding-list-style-type:none;color:#333333;font-size:13px;line-height:16px;"> Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.6161

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.6161

     Microsoft Visual C ++ 2010 x64 Redistributable - 10.0.40219

     Microsoft Visual C ++ 2010 x86 Redistributable - 10.0.40219

     And any time I tried to run the SP1 for these all it was doing was repairing it...

     Do you think I should uninstall all of these and than try to install management studios?

    How important are any of these to have on my laptop? 

    Some times it says Compiler has stopped, what does this mean?

    Thursday, October 25, 2012 12:06 AM
  • These were all pre installed on my lap"border:none;font-family:'Segoe UI', 'Lucida Grande', Verdana, Arial, Helvetica, sans-serif;margin-outline:0px;padding-right:0px;padding-list-style-type:none;color:#333333;font-size:13px;line-height:16px;"> Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x64 9.0.30729.6161

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.17

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.4148

     Microsoft Visual C ++ 2008 Redistributable - x86 9.0.30729.6161

     Microsoft Visual C ++ 2010 x64 Redistributable - 10.0.40219

     Microsoft Visual C ++ 2010 x86 Redistributable - 10.0.40219

     And any time I tried to run the SP1 for these all it was doing was repairing it...

     Do you think I should uninstall all of these and than try to install management studios?

    How important are any of these to have on my laptop? 

    Some times it says Compiler has stopped, what does this mean?

    Thursday, October 25, 2012 12:07 AM
  • I don't why css styles are being added to my message, I was just copying and pasting my previous message... 
    Thursday, October 25, 2012 12:08 AM
  • Would you please try installing Visual Studio 2008 Express with SP1 from below

    http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=14597

    then re-install SQL Server 2088 


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, October 25, 2012 12:16 AM
    Moderator
  • I don't understand.. Do you want me to uninstall sql off my lap top first and then installing express with sp1 or can I just run the sp1 files first and then try to add management tools to my sql?
    Thursday, October 25, 2012 12:25 AM
  • This is the message I get if I try to run any file from the link you sent me. 

    Setup has detected that this computer does not meet the requirements to install this update. The following issues must be resolved before you can install Microsoft Visual 2008 SP1 software update.

    Installing Requirements:

    A compatible version of Visual Studio 2008 was not detected on the system. This update is designed for only the Microsoft Visual Studio(ENU) product family, and is not compatible with any Express edition. 

    Thursday, October 25, 2012 12:28 AM
  • Would you please check-out below workarounds

    http://support.microsoft.com/kb/956139

    http://social.msdn.microsoft.com/Forums/en/sqltools/thread/20e3dbc2-913a-4433-be7d-7f6ef81625cf

    http://social.msdn.microsoft.com/Forums/en-AU/sqlsetupandupgrade/thread/5b4401c8-30f1-44b9-84c3-58927077dce6


    FAQ
    ----
    Regards,
    Ahmed Ibrahim
    SQL Server Setup Team
    My Blog
    This posting is provided "AS IS" with no warranties, and confers no rights. Please remember to click "Mark as Answer" and "Vote as Helpful" on posts that help you.
    This can be beneficial to other community members reading the thread.
    View Ahmed Ibrahim's profile on LinkedIn

    Thursday, October 25, 2012 1:05 AM
    Moderator
  • Yeah thanks but none of those help me out... I am not sure what to do ... 
    Thursday, October 25, 2012 1:20 AM
  • I am meeting my Professor tomorrow and he says he will help. I will tell you how it goes.. Thanks for all your help. I know it's hard to help someone when you do not exactly know what the person has installed on their computer... 
    Thursday, October 25, 2012 5:36 AM
  • Hi, this is Jeff...

    I've got a TOSHIBA SATELLITE L775D, and yes, I was having this ridiculous problem, and yes, I applied ERIC'S registry-fix from above, and YES, IT WORKED.

    I was able to load SQL SERVER 2008 EXPRESS MANAGEMENT STUDIO with no further problems.

    THANK YOU, ERIC, FOR YOUR HELP !!!


    Jeff McVey

    Friday, November 09, 2012 2:27 AM
  • SQL Server 2008 R2 includes a core installation of Visual Studio 2008 in order to handle the Common Language Runtime capabilities inside SQL Server. This is why the SSMS checks the versioning information.

    However, since Microsoft intentionally omitted SSMS from the SQL Server Express installer to keep it light-weight, they subsequently had to release a special installer for only installing SSMS on a system with SQL Server Express to cater to the many developers.

    Unfortunately, the SSMS for SSE requires VS SP1, whereas the SSE installer only includes VS RTM.

    Normally, you could just run Microsoft Update (not Windows Update, as you are actually updating a Microsoft product, not the Windows OS), and install VS SP1 from there, but due to the nature of the install via SSE, Microsoft Update does not detect that you have Visual Studio 2008 installed (it does not show up under Programs and Features).

    You are then left with the solution reported by ericmar, "fooling" the SSMS installer into thinking VS SP1 is installed - which could have unintended consequences, or you can download and install VS 2008 SP1 separately, via the Microsoft Downloads site

    http://www.microsoft.com/en-us/download/details.aspx?id=10986

    after you've installed SSE, but before you install SSMS.

    Wednesday, November 28, 2012 4:09 AM
  • Running the SP1 update would be fine, but this is a problem with (toshiba?) PCs even when they don't have VS 2008 installed. I'm not about to install VS 2008 just so I can run SQL Server, especially considering VS 2008 is 2 versions old as of the time this reply has been written.

    That said, I'm all for not doing things that may have unintended consequences, like changing registry values most certainly would. So if you do have VS 2008 installed already, you should definitely be looking at installing SP1.

    • Edited by ajbeaven Friday, April 05, 2013 6:28 AM be nicer
    Friday, April 05, 2013 6:07 AM
  • This IS a nightmare.  I did Eric's hack first on just VS8 and then tried also on VS10 registry key (similar DevDiv\VS\Servicing\10.0\vstscore\1033\SPIndex was 0, I made it 1) No luck.

    I completely removed all SQL Server and VS products, no luck.

    I do have a 64 bit machine.

    The SQL Server 2008 R2 installation center is still failing at

    Install_trin_aide_Cpu32_Action:CA_BlockOnVSSP0_x86.

    Any further ideas appreciated.

    Tuesday, April 09, 2013 10:12 PM
  • thank u thank u and thank u  ericmar

    i need to say thanku 10000000000 times

    this problem was in my computer since 2 months

    thank u it is solved exactly when i follow your registery steps

    thanku


    • Edited by ahmadmsc Thursday, June 13, 2013 11:40 AM
    Thursday, June 13, 2013 11:38 AM
  • Hi Eric,

    You solution works, thank you for saving me a lot of time.

    I already spent one day on this.

    Heidi

    Thursday, June 27, 2013 6:37 PM
  • Thanks to you, I only lost half a day. You can also see this link terenceluk.blogspot.fr/2013/05/installing-sql-server-2008-r2.html

    I have had this problem on a HP server (to be original) with Visual C++ redistributable installed.
    Thak you very much, you saved some people with this.

    Saturday, January 04, 2014 11:45 AM
  • this trick might also work.

    http://sqlserver-help.com/2011/12/08/help-getting-visual-studio-service-pack-error-while-installing-sql-server-2012-release-candidate-0-rc0/


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog | Team Blog | @Twitter
    Author: SQL Server 2012 AlwaysOn - Paperback, Kindle

    Saturday, January 04, 2014 11:58 AM
    Moderator
  • Thanks a million times over! Registry hack worked like a charm. My PC is a Toshiba P750. Would've never figured this out without your post.
    Tuesday, January 21, 2014 8:33 PM
  • Eric, you are a star! Toshiba Satellite, Windows 7 Home x64. Your fix is confirmed.
    Thursday, June 19, 2014 2:37 AM
  • This resolved my issue thanks for your suggestion.
    Monday, August 18, 2014 8:48 AM
  • super , worked for me :) :)
    Tuesday, March 22, 2016 1:24 PM