Installation Failed; Possibly Due to Collation?

by Jun 4, 2021

Good afternoon.  I just tried to install SQL DM, but got "IDERA SQLdm Installation was unsuccessfull (sic)."  Looking in the log file at C:Program FilesIDERASQLdm x64 Installation KitInstallSQLDM.log, I see just one thing which looks like it could be the cause:

1: ADO Error: Number: -2147217900 Description: The object 'ReverseMojibake' is dependent on database collation. The database collation cannot be changed if a schema-bound object depends on it. Remove the dependencies on the database collation and then retry the operation. Source: Microsoft SQL Server Native Client 11.0 SQL State: 42000 Native Error: 5075
1: ADO Error: Number: -2147217900 Description: CREATE DATABASE failed. The default collation of database 'SQLdmRepository' cannot be set to 'SQL_Latin1_General_CP1_CS_AS'. Source: Microsoft SQL Server Native Client 11.0 SQL State: 42000 Native Error: 1806
1: There was a SQL scripting error at line 71. Aborting the setup.
MSI (s) (94!24) [11:41:58:831]: Product: IDERA SQL Diagnostic Manager (x64) -- Error 27506.Error executing SQL script SQLdmDatabaseInstall.sql. Line 71. CREATE DATABASE failed. The default collation of database 'SQLdmRepository' cannot be set to 'SQL_Latin1_General_CP1_CS_AS'. (1806)

It would be nice if the installer gave some hint as to the problem!  The ReverseMojibake() UDF mentioned above is a little unusual: it reverses mangled Unicode to try to get back to the original accented characters, so it includes lots of non-ASCII characters in REPLACE() functions.  However, non-ASCII characters are hardly a new thing!  It's hard to believe that such could break the installer.

Any idea what might be going on?  Are there other places I should look beyond this log file, for clues as to the problem?

Thank you.


Here's the log file, if relevant:

community.idera.com/…/InstallSQLDM.log