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