Hi Readers,
I thought I would note that I had a customer who had SQL Server installed from a purchased SQL 2008 R2 in Canada. Depending on the country it is possible that default collation may be different than that of the default installed by MAX. The MAX DB install in the default English US Collation
SQL_Latin1_General_CP1_CI_AS
But SQL Server media purchased in Canada has the collation of
Latin1_General_CI_AS
The customer was having a lot of trouble with the software – one option was to change the default on the installed instance which can be quite involved but we decided due to some other factors in the original setup that they remove and reinstall as the quickest and most efficient way to handle the situation.
We changed the Instance default to SQL_Latin1_General_CP1_CI_AS – reattached the MAX DBs and all was well.