SQL Server Troubleshooting: The NT service 'MsDtsServer120' could not be started while patching
https://msdnshared.blob.core.windows.net/media/2016/08/0841.NinjaAwardTinySilver.png won for may2019
Pre-request :-
Before patching, you have take backup of system database,user database and myresourse database suing copy option.
Introduction:
We have started patching, there was following error occurred.
Details:
Overall summary:
Final result: The patch installer has failed to update the following instance:. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The NT service 'MsDtsServer120' could not be started.
Start time: 2019-05-13 22:26:11
End time: 2019-05-13 22:54:06
Requested action: Patch
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.6024.0&EvtType=0xAE7B8BF3%400xF762992B%401202%401&EvtType=0xAE7B8BF3%400xF762992B%401202%401
Instance MSSQLSERVER overall summary:
Final result: The patch installer has failed to update the shared features. To determine the reason for failure, review the log files.
Exit code (Decimal): -2068709375
Exit facility code: 1202
Exit error code: 1
Exit message: The NT service 'MsDtsServer120' could not be started.
Start time: 2019-05-13 22:31:31
End time: 2019-05-13 22:43:31
Requested action: Patch
Exception help link: http://go.microsoft.com/fwlink?LinkId=20476&ProdName=Microsoft+SQL+Server&EvtSrc=setup.rll&EvtID=50000&ProdVer=12.0.6024.0&EvtType=0x0EE19F0D%400xF762992B%401202%401&EvtType=0x0EE19F0D%400xF762992B%401202%401
Machine Properties:
Machine name: xxxxxx
Machine processor count: 8
OS version: Windows Server 2012
OS service pack:
OS region: India
OS language: English (United States)
OS architecture: x64
Process architecture: 64 Bit
OS clustered: No
Event viewer:
Cause:
After checking event log there was issue in log in failure due to password change by windows team.
Solution:
We have rerun setup, it was successful