info@techdevops.com
TechDevOps.com
Explore Tools
Experts in Microsoft SQL Server Operations, Performance, Replication, Cloud & Migrations



SQL Server 2014 Service Pack 2 (SP2) installation failed
by BF (Senior MSSQL Operations - Enterprise, Cloud, Strategy)
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.