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?
This is most likely a firewall issue. Since it appears that you are using a named instance, the actual ports used by the instance "float" (are randomly assigned). This makes opening the appropriate firewall ports a problem. See this MS link for more details: https://social.technet.microsoft.com/Forums/ie/en-US/d9c10c1c-f21d-453e-b1ba-345a509c58b2/error-27502-could-not-cnnect-to-microsoft-sql-server-servernameinstancename?forum=sqldataaccess
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 the suggestion Brendt. The instance is already assigned a static port.
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?
I know that SQLDM made some updates to the installer to support TLS 1.2 environments. I believe that the installer currently relies on SQL Server 2012 Native Client QFE since it was one that Microsoft to support TLS 1.2. You can still install that native client even if you are running 2008 R2.
Thank you very much for the direction Tep - it worked. I wish the page at http://wiki.idera.com/display/SQLDM/SQL+Diagnostic+Manager+requirements had the correct information.
Confirmed. Downloading and installing SS 2012 Native Client QFE worked for me. Thanks!