In this blog post, I'll be guiding you through the installation of the SQL Diagnostic Manager and the IDERA Dashboard in a trial environment. In the steps below, I'll use the default directories. Just something to keep in mind as you perform the installation in your environment.
The steps below will walk you through the installation of the SQL Diagnostic Manager trial.
The steps below will check to see if the required registry values were created successfully. These registry values are required in order to successfully register SQL Diagnostic Manager into the IDERA Dashboard (which will be performed in a series of steps later). These registry values should have been created once the installation of SQL Diagnostic Manager had completed successfully.
If these registry values exist and are populated, then you can proceed to the next section. If these registry values are missing or do not have any data values, then you'll need to uninstall SQL Diagnostic Manager and reinstall the product using the steps above.
In order to install the IDERA Dashboard in a trial environment, we'll need to manually run the MSI file. The IderaDashboard.msi file can be located within the C:\Program Files\Idera\SQLdm x64 Installation Kit\x64 (the path where we extracted files to when installing SQL Diagnostic Manager).
At this point, the installation of SQL Diagnostic Manager and the IDERA Dashboard have been completed. The next step will be to register the SQLDM product into the IDERA Dashboard which will be covered in the following section.
In this section, we'll go over the steps to properly register SQL Diagnostic Manager in the IDERA Dashboard. In order to complete the registration successfully, the registry values noted above must exist on the system where the SQLDM services are installed. Once the product has been registered, then the SQLDM Web Console will be accessible.
At this point, accessing SQLDM might not display any data as we have not yet registered any SQL Server instance to be monitored by SQLDM (at least if you followed the exact steps listed above). You'll need to register some servers to be monitored through the SQLDM Desktop Console before you'll be able to see any data in the SQLDM Web Console.
NOTE: If you are installing the 10.4.0.3432 or 10.5.0.3675 the version of SQLDM, you'll need to perform a few additional steps listed which are listed below.
The information above should, generally, walk you through the process of installing the IDERA Dashboard and registering SQLDM in a trial environment. If you should run into any problems, please reach out and we'll assist you!