Unable to install SQLdm

by Mar 8, 2017

I get the following errors while trying to install SQLDm. I downloaded the trial product for 14 days from this site.

1. IDERA SQL Diagnostic Manager Installation

Error : 27506. Error executing SQL Script SQLdmDatabaseInstall.sql. Line 191. SELECT failed because following SET options have incorrect settings:"ANSI_WARNINGS". Verify that set options are correct to use with indexed views and/or indexes on …

2. IDERA Dashboard Setup.

Error : -2147217900. Failed to execute SQL String. Error Detail : An object or column name is missing or empty. For SELECT INTO statements verify each column has a name. For other statements, look for empty alias names.

3. IDERA SQL Diagnostic Manager Installation

Error: 27506. Error executing SQL Script SQLdmDatabaseInstall.sql. CREATE DATABASE failed. Some file names listed could not be created. Check related errors (1802).

I have screenshots of the above errors but couldn't upload as the file upload size limit is 64kb.

Please advice on how to proceed further.