Page tree

Upgrading from versions 2.2 and lower

Because of the addition of roles, all user accounts in versions 2.2 and previous are added to the IDERA Dashboard but are not assigned a role and cannot access IDERA SQL Inventory Manager until the administrator changes the account permissions. Note that the administrator is the account specified during the IDERA Dashboard installation.

To change user account permissions, go to IDERA Dashboard > Administration > Manage Users. Edit a user account. Select the IDERA SQL Inventory Manager product, and then assign a role of Product Administrator, Product User, or Product Guest. Click Save, and then repeat these steps for each user account.

Now grant the user accounts access to the instances in your environment. Go to SQL Inventory Manager > Administration > Manage Users. Click the link for the name of the user account. In the Access to SQL Server Instances section of the Edit Users window, select whether you want to grant the user account access to all instances or a selection of instances. If you want to grant access to only selected instances, choose those instances using either the tag or instance name. Click Save.

For more information about user accounts and roles, see Managing users in the IDERA Dashboard.

2.6.1 New features

Cloud discovery

  • IDERA SQL Inventory Manager 2.6 now allows you to discover cloud instances whether on Azure VM, Amazon EC2, Azure Database or Amazon RDS.

Advanced filters

  • Users can create advanced filters on Instances views .

Exclude drives from Volume at Risk threshold

  • Users can now exclude drives from alerts on the Volume at Risk health check.

Support For SQL Server 2019

  • IDERA SQL Inventory Manager 2.6 now supports SQL Server 2019 for monitored instances.

2.6 New features

Cloud discovery

  • IDERA SQL Inventory Manager 2.6 now allows you to discover cloud instances whether on Azure VM, Amazon EC2, Azure Database or Amazon RDS.

Advanced filters

  • Users can create advanced filters on Instances views.

Exclude drives from Volume at Risk threshold

  • Users can now exclude drives from alerts on the Volume at Risk health check.

Support For SQL Server 2019

  • IDERA SQL Inventory Manager 2.6 now supports SQL Server 2019 for monitored instances.

2.6.2 Fixed issues

  • User Account Control window displays SQLInventoryManager properly when installing SIM 2.6.2.
  • SIM 2.6.2 adds any unreachable instance correctly, and displays the proper informational message.
  • User Account Control window displays IDERA as the SQL Inventory Manager publisher.
  • SIM 2.6.2 registers successfully SQL Server instances, and cloud instances with SQL credentials only.
  • SIM 2.6.2 gets registered successfully, and all the navigation screens work properly after being installed to CWF 4.6.0.40 with FIPS compliant for hashing, and signing, enabled.
  • The Web Application logs do not show the password details in plain text anymore. 
  • SIM 2.6.2 discovers SQL Instances hosted in other domains properly.
  • The SQL Server is Down alert is properly described in Manage Health Checks.
  • In the Explorer view, the data now displays correctly, ordered by size, sorted in descending order, and with proper values till two decimal places.
  • The Instance is Down email alerts work as expected after upgrading SIM.
  • The Repository is installed/upgraded correctly, even when the database name is changed from the default settings.
  • After entering the vCenter information in the Manage VM Configuration, the settings for VM configuration are saved and work properly.
  • When reports to SSRS are deployed, these reports share data source configured with appropriate value and custom data source as empty.
  • SIM 2.6.2 is successfully installed on Windows Server 2012 with SQL Server 2014 Standard.
  • Databases on the secondary node of an Availability Group do not raise Databases Without a Backup health checks anymore. 
  • Dropped databases do not show up in the Databases list displayed under the Instance Details page.
  • Custom field value from the Instance Summary view, now fully displays.
  • The comments added to the Database Details screen for a monitored database are properly displayed when the p_InsertUpdateDatabase stored procedure runs as part of a data refresh.
  • The Data Space at Risk alert works properly when Autogrowth is either disabled, enabled with limited file size, and enabled with unlimited file size.

2.6.1 Fixed issues

  • SIM Charge Back Reports now runs properly.

  • When  the user is modified, SQL Inventory Manager 2.6.1 restarts collector Service after completing the save operation.

  • SQL Inventory Manager 2.6.1 displays correct time stamp for database backups (full, differential, and log) in database details.

  • Users can set a range for ports input in Manage Discovery options.

  • SQL Inventory Manager 2.6.1 displays the appropriate core factor for each SQL Server version under SQL Licensing by Instances view.

  • Users can add a New Virtualization Host Servers in the Manage VM Configuration window.

  • E-mail shows alert with Alert Level, Instance Name, and the explanation of the alert.

  • All passwords are encrypted when stored and when transmitted.

  • The Administrator tab visibility is now invisible for Product User.

  • SQL Inventory Manager 2.6.1 disables the Display Name text field while upgrading SIM.

  • The Explorer tab displays only the tags associated with instances under Instance Tags section, and tags associated with databases under Database Tags section.

  • The Dashboard > Administration Tab > Manage Tags window shows all the tags to edit or view their properties correctly.

  • Loading and refreshing pages run faster than older versions.

  • SQL Inventory Manager 2.6.1 imports instances configured with custom instance tags that already exist, without duplication issues.
  • User Account configured for monitoring and discovering instances from a different domain, now authenticates properly on the server hosting SIM.

  • The console does not display dropped databases, and they are not shown Online.

  • SQL Inventory Manager 2.6.1 performs Health Checks for databases on secondary nodes of Availability Groups properly.

  • The SSIS version displays correctly.

  • The User Account Control window displays IDERA as the SQL Inventory Manager 2.6.1 Verified Publisher in the installation folder.

  • After installing SQL Inventory Manager 2.6.1 using the default ports, the launch page now links to the correct URL.

2.6 Fixed issues

  • IDERA SQL Inventory Manager locks the service account.
  • SQL Inventory Manager 2.6 sends automatic email alerts properly.