info@techdevops.com | 437-991-3573 | Data Engineering Services
TechDevOps.com
Resources Tools
Experts in Microsoft SQL Server on Windows, Linux, Containers | Clusters, Always On, FCI | Migrations, Cloud, Performance



SQL Server 2014 Service Pack 2 (SP2) installation failed
by BF (Principal Consultant; Architecture; Engineering)
2017-11-29









SQL Server 2014 SP2 Installation failed: The patch installer has failed to update the following instance: MSSQLSERVER. To determine the reason for failure, review the log files.



Setup Log File for SQL Server 2014 SP2:

C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\Summary.txt


C:\Program Files\Microsoft SQL Server\120\Setup Bootstrap\Log\20171122_192914\MSSQLSERVER\Detail.txt




Issue: (for this specific case)

The SQL Server Server Properties - Database default locations - had Data and Log paths that did not exist.


Resolution:

1. Create File Systems locations for Data and Log or point to existing locations.

2. Edit the SQL Server Server Properties - Database default locations - and enter the locations for Data and Log files to be stored.

3. Re-run SQL Server 2014 SP2.