Users: 15,000+ | Page Views: 50,000+ | PPS: 2.5
TechDevOps.com
Explore Tools
{Experts in Microsoft SQL Server Operations, Performance, HA/DR, Data Migrations & Cloud Computing}



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.