Solved

SQL Server 2014 installation

Posted on 2016-08-05
14
133 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
  • 8
  • 6
14 Comments
 
LVL 48

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 48

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
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 

Author Comment

by:Morpheus7
ID: 41747017
Hi,

The install media includes the full setup with SP1.

Thanks
0
 
LVL 48

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 48

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 48

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 48

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 48

Accepted Solution

by:
Vitor Montalvão earned 500 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 48

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

856 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