?
Solved

SQL Server 2014 installation

Posted on 2016-08-05
14
Medium Priority
?
227 Views
Last Modified: 2016-08-11
Hi,

I am trying to install SQL Server 2014 Standard edition and almost at the end of the process, it returns an error that there is an 'Invalid config file'. Click on ok and then process continues and completes. When reviewing the installed components Reporting Services has failed to install.

Had a look at the MS site but of no help. Has anyone else had this error?

Many thanks
0
Comment
Question by:Morpheus7
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
14 Comments
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41744099
We'll need to analyze the installation logs to try to understand what happened.
They are:
%programfiles%\MicrosoftSQL Server\120\Setup Bootstrap\Log\Summary.txt
%programfiles%\MicrosoftSQL Server\120\Setup Bootstrap\Log\<YYYYMMDD_HHMM>\detail.txt

Where YYYYMMDD_HHMM is the exact date and time of the installation.
0
 

Author Comment

by:Morpheus7
ID: 41746989
Hi,

Please see attached log files as requested.

Thanks
Summary_XXXXXXXXX_20160808_091241.txt
Detail.txt
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41746991
Where did you get the SQL Server setup files from?
Looks like it's only the SP1 and not the RTM media file.
0
Does Your Cloud Backup Use Blockchain Technology?

Blockchain technology has already revolutionized finance thanks to Bitcoin. Now it's disrupting other areas, including the realm of data protection. Learn how blockchain is now being used to authenticate backup files and keep them safe from hackers.

 

Author Comment

by:Morpheus7
ID: 41747017
Hi,

The install media includes the full setup with SP1.

Thanks
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41747059
The install media includes the full setup with SP1.
Like in a slipstream? That's not possible anymore since SQL Server 2012. Now you have the /UPDATESOURCE option where you can indicate the location of the service packs.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41747069
Can you provide the configuration file?
C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20160808_091241\ConfigurationFile.ini
0
 

Author Comment

by:Morpheus7
ID: 41747078
Hi,

Please see attached.

Thanks
ConfigurationFile.ini
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41747081
If you try installing without Reporting Services it will work?
0
 

Author Comment

by:Morpheus7
ID: 41747088
Hi,

Yes it completes successfully.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41747107
By the detail.txt the error occurred with Reporting Services:
(01) 2016-08-08 09:27:24 Slp: Invalid config file
(01) 2016-08-08 09:27:24 Slp: Watson bucket for exception based failure has been created
(01) 2016-08-08 09:27:41 Slp: Error: Action "SqlRSConfigAction_install_ConfigNonRC_Cpu64" failed during execution.
(01) 2016-08-08 09:27:41 Slp: Completed Action: SqlRSConfigAction_install_ConfigNonRC_Cpu64, returned False
Where did you get the slipstream from?
0
 

Author Comment

by:Morpheus7
ID: 41747111
From our software repository which is managed by our Tech  guys.
Should I download another file from MS?
0
 
LVL 51

Accepted Solution

by:
Vitor Montalvão earned 2000 total points
ID: 41747117
I just wanted to know how they slipstreamed it since the configuration is not to use Microsoft Update:
USEMICROSOFTUPDATE="False"
UpdateSource="MU"


My guess is that slipstream isn't working for Reporting Services. You may need to install Reporting Services from another media and apply SP1 later.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41751936
Morpheus, any news on this question?
0
 

Author Comment

by:Morpheus7
ID: 41752063
Hi,

I have managed to do the install successfully. I used an install package without a service pack, which intalled ok. Then I applied sp 2 successfully.

Thank you for your assistance with this.
0

Featured Post

Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question