How to solve cross language upgrade failed sql server 2016 problem?

M

mr_blond972016-06-07 15:43:41

SQL Server

mr_blond97, 2016-06-07 15:43:41

I'm trying to upgrade sql server 2014 to sql server 2016, it gives an error: cross language upgrade failed sql server 2016. How to solve this problem?
Here it is advised to delete the previous version of the database. This does not fit, I would like to find a normal solution with an update.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

A

Aleksey Ratnikov, 2016-06-08
@mahoho

The problem is solved only by reinstallation - the SQL Server installer is very straightforward and inflexible.
Create database backups, login backups using the following article: https://support.microsoft.com/en-us/kb/918992 (it describes the creation of a procedure whose execution will generate T-SQL code for creating logins). Delete the old instance, install a new one, restore logins with the code obtained above, restore the database from backups.
Not as difficult as it might seem.