SQL Server installation failed (Feature :Business Intelligence Development Studio)

Question

Hi Guys, I try to install SQL Server 200 R2 in Windows 8. All feature is installed successfully except Business Intelligence Development Studio. After the installation I try to run setup again and add the feature, but the result is same.

Here the error log :

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

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):           -2068024469
  Exit facility code:            1212
  Exit error code:               29547
  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:                    2014-11-17 10:25:34
  End time:                      2014-11-17 10:36:16
  Requested action:              Install
  Log with failure:              C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141117_102441\sql_bids_Cpu64_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:                  MT_HASTINFATAH
  Machine processor count:       4
  OS version:                    Future Windows Version
  OS service pack:               
  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.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Edition   10.50.1600.1    No        

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         F:\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\20141117_102441\ConfigurationFile.ini
  CUSOURCE:                      
  ENABLERANU:                    False
  ENU:                           True
  ERRORREPORTING:                False
  FARMACCOUNT:                   <empty>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      BIDS
  FILESTREAMLEVEL:               0
  FILESTREAMSHARENAME:           <empty>
  FTSVCACCOUNT:                  <empty>
  FTSVCPASSWORD:                 *****
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  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\20141117_102441\ConfigurationFile.ini

Detailed results:
  Feature:                       Business Intelligence Development Studio
  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\20141117_102441\SystemConfigurationCheck_Report.htm

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Thanks for your help.

Answer 1

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.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         SQL Server Replication                   1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSSQL10_50.MSSQLSERVER         Full-Text Search                         1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSAS10_50.MSSQLSERVER          Analysis Services                        1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2   MSSQLSERVER          MSRS10_50.MSSQLSERVER          Reporting Services                       1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Basic                 1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Management Tools - Complete              1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools Connectivity                1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools Backwards Compatibility     1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Client Tools SDK                         1033                 Enterprise Edition   10.50.1600.1    No        
  Sql Server 2008 R2                                                       Integration Services                     1033                 Enterprise Edition   10.50.1600.1    No       

You already have SQL Server 2008 r2 enterprise installed as per discovery report. Were you trying to install new named instance ?. If default is only instance  you need to uninstall this default  remove program. I guess you tried many times. Before that can you upload log from below location on shared drive/one drive/shared location  for analysis. Please share link for location here so that i can access it.

C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141117_102441\sql_bids_Cpu64_1.log

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

Answer 2

Dear Shanky,

Thanks for your Reply.

Actually I have had already installed SQL Server 2008 R2 with custom instance including all features before I install the new installation. But I could not connect Database Engine. So, I removed it, and deleted related files including instance files. In the new installation I use default instance MSSQLSERVER, and I can connect Database Engine. The installation of All Feature is OK except BIDS.

You can download C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20141117_102441\sql_bids_Cpu64_1.log with this link

https://www.dropbox.com/s/9tjvkcvhbpqucbj/sql_bids_Cpu64_1.log?dl=0

Thanks for Your Help.

Best Regards,

Alfan

Answer 3

Do you have Visual studio installed ? What is SP level of Visual studio ? Its difficult to find why this error occurred. I can only try.

Few error messages

Error Code: -2147467259
SQL Server 2008 R2 BI Development Studio -- Error 29547. Upgrade Failed due to the following Error.
The error code is :-2147467259.Message:Unspecified error

MSI (s) (24:3C) [10:36:08:666]: Windows Installer installed the product.
 Product Name: SQL Server 2008 R2 BI Development Studio. Product Version: 10.50.1600.1.
 Product Language: 1033. Manufacturer: Microsoft Corporation. Installation success or error
 status: 1603.

Can you have a look at This connect Item

Have you made sure you meet all hardware and software requirements ?

---

Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

My Technet Wiki Article
MVP

Answer 4

Dear Shanky,

Thanks for your Reply..

I have Visual Studio 2010 Ultimate but I have not installed it. It is my program list https://www.dropbox.com/s/iccvw8ae9in53mg/Program.jpg?dl=0 and my windows feature list https://www.dropbox.com/s/da4cl0c9cb5blgw/Windows%20feature.jpg?dl=0

Answer 5

Should I Install VS 2010 Ultimate?

Answer 6

Dear Shanky,

Thanks Shanky for your help, I have installed VS 2008 SP1, the BIDS installation is sucess.

Best Regards,

Alfan FT