SQLdmDatabaseInstall.sql incorrect settings: 'ANSI_WARNINGS'

by Jul 24, 2017


can you help me with IDERA SQL Diagnostic Manager Installation please ? My boss asked me to try and choose best monitoring tool for our SQL Servers. I am trying IDERA now, downloaded trial version but i am not able to install Diagnostic Manager.


Product: IDERA SQL Diagnostic Manager (x64) — Error 27506.Error executing SQL script SQLdmDatabaseInstall.sql. Line 103. SELECT failed because the following SET options have incorrect settings: 'ANSI_WARNINGS'. Verify that SET options are correct for use with indexed views and/or indexes on computed columns and/or filtered indexes and/or query notifications and/or XML data type methods and/or spatial index operations. (1934)


We are using MS SQL 2016 (13.0.4435) on Windows Server 2016. (64 logical CPU, 1 TB RAM)


Thnak you for your help