Receiving the following message when trying to install:
IDERA SQLdm Installation was unsuccessfull.
The %PROGRAMFILES%\Idera\SQLdm x64 Installation Kit\InstallSQLDM.log file has the following:
1: Attempting to establish the SQL connection... Server: XXXXXX\YYYYYYY, Database: MSI (s) (A8!D0) [11:58:43:101]: Product: IDERA SQL Diagnostic Manager (x64) -- Error 27502.Could not connect to Microsoft SQL Server 'XXXXXX\YYYYYYY'. Provider cannot be found. It may not be properly installed.Error 27502.Could not connect to Microsoft SQL Server 'XXXXXX\YYYYYYY'. Provider cannot be found. It may not be properly installed.CustomAction ISSQLServerInstall returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
where XXXXXX\YYYYYYY is redacted.
Does anyone know how I can find out what the actual issue is?
Based on the error message, I think it's looking for a native client. I suspect it's looking for a specific version of the native client, SQL Server 2012 Native Client QFE to be specific. You should be able to easily download it, install it, then try the SQLDM installer again.
Confirmed. Downloading and installing SS 2012 Native Client QFE worked for me. Thanks!