SQL Compliance Manager is ONLY compatible with IDERA Dashboard version 4.8.1 and with limited support.

Once you have installed and configured your IDERA Dashboard and IDERA SQL Compliance Manager deployments, you can login to the IDERA Dashboard by doing the following:

  1. Stop the IDERA Dashboard Core Service, which would also stop the IDERA Dashboard Web Application Service.
  2. Navigate to the CoreService\ProductPlugins\War directory within the Dashboard installation directory (e.g. C:\Program Files\IDERA\Dashboard\CoreService\ProductPlugins\War)
  3. Rename the 6.1 WAR file to sqlcm-war-6.1.0.774_#_original.war
    Note that the '#' character will represent the Product ID.
  4. Copy the 6.0 WAR file into the directory (Please reach out to support@idera.com to get the 6.0 war file).
  5. Rename sqlcm-war-6.0.0.77_2.war to sqlcm-war-6.1.0.774_#.war (replace # with the correct number).
    You can double-check the name by checking the Dashboard repository database.
    SELECT[ID],[WarFilePath]
FROM [IderaDashboardRepository].[Common].[RegisteredProducts]
WHERE Name='SQLCM'
  6. Execute the following query to make sure the version is correct.
    UPDATE [IderaDashboardRepository].[Common].[RegisteredProducts] SET [Version]='6.1.0.774' WHERE [WarFilePath] LIKE '%sqlcm-war-6.1.0.774%'
  7. Restart the Dashboard Services

The IDERA Dashboard Web Application service comes with SSL already set up. For more information on running the IDERA Dashboard over SSL, see Run the Idera Dashboard over SSL (HTTPS)



IDERA | Products | Purchase | Support | Community | Resources | About Us | Legal