I'm trying to migrate a DB from SQL 2005 to SQL 2014 Standard. Vendor provided an application that migrates the DB between servers. I'm able to connect to the source but getting this error when connecting to the target
SET LANGUAGE failed because 'English' is not an official language name or a language alias on this SQL Server
Instance runs on Server 2012 R2.
I made sure the English language is set properly in SQL server properties and made sure my Local Settings are set to English
For testing I installed the same SQL version on Win 10 box and able to connect with no problems
I googled for solution for a long time and did not find anything that applies to my situation
would appreciate any help