IDERA SQL Inventory Manager provides fundamental information on your SQL Servers to help you manage and keep track of your database environment without having to be an expert in Microsoft SQL Server. It gives a broad enterprise-wide view of all your SQL Servers through automated discovery as well as simple, actionable information about the state of your environment. View core information such as how many databases exist, whether they are being backed up, get access to options like availability monitoring, and notification emails so you can take action as needed.
IDERA strives to ensure our products provide quality solutions for your SQL Server needs. If you need further assistance with any issue, please contact Technical Support.
The following issues are known in this version of SQL Inventory Manager:
Because of the addition of roles, all user accounts in a previous version of the product are added to the IDERA Dashboard but are not assigned a role and cannot access 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 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 wither the tag or instance name. Click Save. For more information about user accounts and roles, see Managing users in the IDERA Dashboard. |
SQL Inventory Manager 2.2 and later no longer support the use of SQL Server 2005 as a repository. The product does continue to support discovered and managed instances on SQL Server 2005.
Users who have AlwaysOn Availability Group environments may notice errors caused by the unreadable state of the secondary cluster node.
Scanning cross-domains using multiple accounts/credentials will not yield any discovered instances even if one of the supplied credentials in the multiple accounts setting is correct for that domain. At this time, multiple accounts/credentials only work for the same domain. For example, in your environment, SQL Inventory Manager 2.0 is installed on domain A and you request a scan of domain B. Even when using credentials that are included in the multiple credentials list, SQL Inventory Manager does not return results that include data from any outside domain. As an alternate, you can run the specific domain scan using specific Windows user or SIM service account (under the domain setting).
Discovery Status displaying incorrect value for scans other than SQL Server Resolution Services. When you run a scan using method other than SQL Server Resolution Services, it will run and scan and discover instances using the selected method. However, the discovery status log will have an incorrect log referencing SQL Server Resolution Services.
When using the Setup Wizard to manage discovery, the IP Address Ranges and Domain Run Scan Now option is disabled even though an IP address or domain is selected. The workaround is to uncheck and then recheck those options.
In order to connect to a named instance on Amazon RDS, use the following format:
machinename\instancename,port
In environments with a large number of monitored instances, the Health Check Recommendations are not immediately updated when you decommission and recommission databases. There will be a slight delay for the health check recommendations to refresh.
In order to set up user account for email alerts, you first must set up and enter individual email addresses in the SQL Inventory Manager Manage Administration page. User accounts added using the Manage Users link in the IDERA Dashboard Administration tab do not have their associated email address appear when viewing the account in the SQL Inventory Manager Manage Users and Subscriptions window.
In order to select the All Instances option for user permissions, you must select the hyperlink for that user account in the Manage Users and Subscriptions window. Select All Instances, and then click Save.
SQL Inventory Manager lets you discover and visualize your SQL Server environment. Learn more > > |
| IDERA Website | Products | Purchase | Support | Community | About Us | Resources | Legal |
|---|