Solved

SQL Server 2014 installation

Posted on 2016-08-05
14
63 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 45

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 45

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
 

Author Comment

by:Morpheus7
ID: 41747017
Hi,

The install media includes the full setup with SP1.

Thanks
0
 
LVL 45

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 45

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
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 
LVL 45

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 45

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 45

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 45

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

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 …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now