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.
Thank you for your reply Tep. SQL server is 2008 R2. How do you know the native client in question is 2012? Is the 2012 native client required for all versions of SQL Server?
Confirmed. Downloading and installing SS 2012 Native Client QFE worked for me. Thanks!