In-place migration from 2012R2 to 2016
I'm doing a new installation of SCSM 2016, where we plan to migrate data from a 2012R2 installation.
- The SQL collation on 2012R2 is set to SQL_Latin1_General_CP1_CI_AS
The problem is when I need to install SQL Analysis services and define the Collation - Here I can't select SQL_Latin1_General_CP_CI_AS. The closest I come to this are Latin1_General_CI_AS or Latin_General_CI_AS.
Will this configuration give any problems, and is it supported?