Upgrade SQL Server 2016 to Service Pack 1 faced with Exit code (Decimal): -2068380094

1

I wanted to upgrade the SQL Server 2016 installed on my laptop to service pack 1 last night. But the setup failed with this error:

  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):           -2068380094

What I noticed in the process was that the setup process tried to stop the MSSQLSERVER service, but after about one minute of trying without any success, the setup process finished with the above error code.

2

So, I start analyzing the detail log file. Then, I found the following error code:

(01) 2017-01-20 19:56:47 Slp: Error: Failed to run patch request for instance: MSSQLSERVER (exit code: -2068709375)

There was nothing more than that to identify what was happened in the upgrade process. So, I start checking the sql server configuration manager and faced with two interesting things:

  1. I could not manually stop the MSSQLSERVER service
  2. Polybase Services stuck in Change Pending state

3

So, I had an idea for more investigations! Finally, I found the Greg Low’s following post

http://sqlblog.com/blogs/greg_low/archive/2016/07/06/sql-server-2016-polybase-services-stuck-in-change-pending-state.aspx

He was told that “enabling TCP and restarting made all good”

I check it and he was completely right!

5

I enabled the TCP and restarted and tried setup again with a success!

8

 

Advertisements
This entry was posted in Database Administration, SQL General Information and tagged , , , , . Bookmark the permalink.