DM Database Configuration

by Mar 30, 2016

I have started at a new company 3 days ago, and have many years of experience with Idera. Upon querying the SQLDMRepository database I discovered the database was configured for collation SQL_Latin1_General_CP1_CS_AS, which is Case and Accent Sensitive. This doesn’t seem normal, what is the ‘default’ installation configuration? Note: The Server is not set to this collation.
Version Info:
IDERA SQL Diagnostic Manager Desktop Client
IDERA SQL Diagnostic Manager Repository 10.0
IDERA SQL Diagnostic Manager Management Service
IDERA SQL Diagnostic Manager Collection Service
Microsoft Data Access Component (MDAC) 6.3.9600.16384
Microsoft .Net Framework 4.0.30319.34209
Microsoft Windows Operating System Microsoft Windows NT 6.2.9200.0
SQLDM Mobile and Newsfeed Version