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

Answer 1

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

Answer 2

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.

Answer 3

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

Answer 4

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.

Answer 5

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

Answer 6

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

Answer 7

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.

Answer 8

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.

Answer 9

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?!?

Answer 10

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

 

 

 

 

 

Answer 11

work wunderfull for me. thanks !

Answer 12

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.

 

Answer 13

Wonderful solution. Worked for me. 

 

Thanks a lot, saved my time. 

Answer 14

Thanks Eric! Your solution worked perfectly for me. And yes, I too was facing this problem on my Toshiba laptop (Satellite Pro R850)

Answer 15

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

Answer 16

Nice Solution. Worked for me also. Thanks a lot.

Answer 17

Hi,

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

---

- Sekilha

Answer 18

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

Answer 19

Thanks a lot Eric ! My Problem has been resolved. 

Answer 20

Thank you Eric,

 

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

 

Thankyou

Regards,

Leon

Answer 21

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 

Answer 22

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...

Answer 23

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

Answer 24

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

Answer 25

Hi eric..Thanks ..It was really a nice explanation...My problem solved in just 2 mins..Thanks a lot ...

Answer 26

Exactly what I needed too, thanks!

Answer 27

Worked for Eric,geat

Thanks

Robin

Answer 28

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

Answer 29

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?!!!!!

Answer 30

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?!!!!!

Answer 31

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?!!!!!

Answer 32

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.

Answer 33

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?

Answer 34

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... 

Answer 35

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.

Answer 36

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. 

Answer 37

What do you think I should do? Because I have never been this frustrated in my life. 

Answer 38

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?

Answer 39

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?

Answer 40

I don't why css styles are being added to my message, I was just copying and pasting my previous message... 

Answer 41

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.

Answer 42

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?

Answer 43

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. 

Answer 44

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.

Answer 45

Yeah thanks but none of those help me out... I am not sure what to do ... 

Answer 46

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... 

Answer 47

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

Answer 48

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.

Answer 49

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.

Answer 50

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.

Answer 51

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

Answer 52

Hi Eric,

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

I already spent one day on this.

Heidi

Answer 53

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.

Answer 54

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

Answer 55

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.

Answer 56

Eric, you are a star! Toshiba Satellite, Windows 7 Home x64. Your fix is confirmed.

Answer 57

This resolved my issue thanks for your suggestion.

Answer 58

super , worked for me :) :)

Answer 59

Thank you so much! 

It worked for me as well :-)

Answer 60

very old post but just had to install SQL management studio 2008R2 on Windows Server 2019 and came across the same error. Box also had older citrix management tools needing Visual C++ 2008, 2010. This regkey change SOLVED THE PROBLEM!!! Took me already hours to try to update something I also had not installed and was not visible. So great post EricMar.