Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

SQL Server 2014 installation

Posted on 2016-08-05
14
Medium Priority
?
273 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 52

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 52

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
Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

 

Author Comment

by:Morpheus7
ID: 41747017
Hi,

The install media includes the full setup with SP1.

Thanks
0
 
LVL 52

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 52

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 52

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 52

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 52

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 52

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

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

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
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

618 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