We help IT Professionals succeed at work.

SQL Server 2016 upgrade to 2019 full-text & database engine service FAILED

Wayne Barron
Wayne Barron asked
Hello, all;
(Windows 10, latest version, SQL Server 2016 Developer)

OK, I am running a test on my local development system (Laptop)
The test is, running SQL Server 2019 upgrade from SQL Server 2016 SP2
However, I hit the following every attempt
SQL Server 2016 to 2019 upgrade failure
I have run as Administrator and still the same issue.
I have searched for answers on this issue, and I cannot find anything that remotely comes close to this problem.


Here is the output, a summary of it.
Overall summary:
  Final result:                  Failed: see details below
  Exit code (Decimal):           -2068643839
  Start time:                    2020-02-09 16:42:02
  End time:                      2020-02-09 16:46:35
  Requested action:              Upgrade

Setup completed with required actions for features.
Troubleshooting information for those features:
  Next step for FullText:        Use the following information to resolve the error, and then try the setup process again.
  Next step for SQLEngine:       Use the following information to resolve the error, and then try the setup process again.
  Next step for SNAC_SDK:        Use the following information to resolve the error, and then try the setup process again.

Detailed results:
  Feature:                       Full-Text and Semantic Extractions for Search
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.

  Feature:                       Database Engine Services
  Status:                        Failed
  Reason for failure:            An error occurred for a dependency of the feature causing the setup process for the feature to fail.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.

  Feature:                       SQL Client Connectivity SDK
  Status:                        Failed
  Reason for failure:            An error occurred during the setup process of the feature.
  Next Step:                     Use the following information to resolve the error, and then try the setup process again.

Open in new window


The SystemConfigurationCheck_Report.htm
Shows all good, with no issues in it.

Any advice would be great.
I want to test this out first on this system, before tackling it on my 2 live SQL servers.

Wayne
Comment
Watch Question

View Solution Only

Distinguished Expert 2017
Commented:
Why not install SQL server along side, then ......

Are your servers virtual?
If VMs, why not build a new VM, install SQL 2019, restored DB, setup the corresponding application that uses the DB to test.

While understand your test, commonly it should be in a similar environment.
Presumably your existing is on Windows server OS, the test is on a desktop OS.
Wayne BarronAuthor, Web Developer
Top Expert 2009

Author

Commented:

Thanks, Arnold.
I was thinking of doing the new VM with SQL 2019 on it and doing as you stated.
However, I wanted to test out the upgrade.
And you are correct.
Testing on the Desktop is going to differ significantly from the VM Server.

Thank you.
I will leave this open for Monday. And see if there are any suggestions on the error.
And then close it out.

arnold
Distinguished Expert 2017

Commented:
It errored on a dependency..
Check the server for SQL related installed components


I, especially, in an SQL server find the inplace upgrade to be risky since it provides no way back if ....it further does not provide for testing, ...

The dependency, full text, SQL client connect and engine ......

The other issue, time has passed, the current resources might be getting closer to an upgrade cycle, ....
Wayne BarronAuthor, Web Developer
Top Expert 2009

Author

Commented:

18.4 is the current version I am using of SSMS.