troubleshooting Question

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

Avatar of Wayne Barron
Wayne BarronFlag for United States of America asked on
Microsoft SQL ServerSQL
5 Comments1 Solution88 ViewsLast Modified:
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.

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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros