Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Added support for SQL Server 2022

IDERA Dashboard and IDERA SQL Inventory Manager services requirements

You need to comply with the following requirements for installing to install the IDERA Dashboard and IDERA SQL Inventory Manager collection services:

TypeRequirementSuggestions
Microsoft
Windows Data Access Components
2
6.
8
0 or later
 

Microsoft .NET Framework version4.
0 or later
6.1

If this software is not already installed on your computer, you must install it prior to the installation of IDERA SQL Inventory Manager.

For more information about the .NET Framework, see the MSDN article .NET Framework Versions and Dependencies.

To check the .NET Framework version you have installed in your computer, follow these steps:

Operating System


  • Windows
XP SP2+
  • 10
  • Windows
Server 2003 SP2
  • 2012
  • Windows
Server 2008 SP2+
  • 2016
  • Windows
Vista SP2+
  • Windows 7
  • Windows 2008 R2
  • Windows 8
  • Windows 2012
  •  
    • 2019
    • SQL Server 2017 on Windows & Linux
    • SQL Server 2019 on Windows & Linux
    • SQL Server 2022 on Windows & Linux

    IDERA Dashboard and IDERA SQL Inventory Manager repository requirements

    To install The IDERA Dashboard and IDERA SQL Inventory Manager repositories you must havesupport any of the following versions for hosting the repositories:

    TypeRequirement
    SQL Server Express, Standard,
    Enterprise Edition, or Express Edition
    or Enterprise/Datacenter Editions
    • SQL Server 2012
    • SQL Server 2014
    • SQL Server
    2008
    • 2016
    • SQL Server
    2008 R2
    • 2017 on Windows & Linux
    • SQL Server
    2012
    • 2019 on Windows & Linux
    • SQL Server
    2014
    • 2022 on Windows

    Monitored

    ...

    SQL Server instances requirements

    All SQL Server instances that you wish to monitor should comply with the following requirements:

    TypeRequirement
    SQL Server Express, Standard,
    Enterprise Edition, or Express Edition
    • SQL Server 2005 SP1+
    • SQL Server 2008 SP1
    • SQL Server 2008 R2
    • SQL Server 2012
    • SQL Server 2014

    Browser requirements

    or Enterprise Edition
    • Windows 10
    • Windows 2012
    • Windows 2016
    • Windows 2019
    • SQL Server 2012
    • SQL Server 2014
    • SQL Server 2016
    • SQL Server 2017 on Windows & Linux

    • SQL Server 2019 on Windows & Linux
    • SQL Server 2022 on Windows & Linux
    • Azure DB
         •Single
         •Elastic Pool
         •Managed Instance
    • Amazon RDS SQL
         •SQL Server 2012
         •SQL Server 2016
         •SQL Server 2017
         •SQL Server 2019
    • Azure VM Windows (All SQL Version)
    • Azure VM Linux (SQL Server 2017 and 2019)

    Browser requirements

    The IDERA Dashboard and IDERA SQL Inventory Manager user interfaces Idera SQL Inventory Manager user interface can be accessed via web with the following browsers:

    • Internet Explorer IE 911.x+
    • Google Chrome
    • Mozilla Firefox
    • Microsoft Edge
    • Safari

    Port requirements

    ...

    The IDERA Dashboard uses the following ports:

    • Web Application Service: 9290 (Standard HTTP port) and 9291 (SSL port)
    • Core Service: 9292 (REST API port) and 9293 (.NET remoting port)

    IDERA Idera SQL Inventory Manager uses the following portsport:

    • Collection service port: 9275
    Warning

    The IDERA Dashboard Web

    ...

    Required Accounts and Permissions

    You need the following accounts and permissions:

    AccountActionPermissions required
    Windows User AccountTo install SQL Inventory Manager componentsWindows Administrator permission on the Target computer

    To create and access the SQL Inventory Manager repository databases

    • Create Database Rights on the target SQL Server Instance
    • Read and write privileges on the SQL Inventory Manager Repository Databases

     

     

    SQL Server login account

    For most SQL queries

    VIEW SERVER STATE

    VIEW ANY DATABASE

    VIEW ANY DEFINITION

    To monitor database information

    ALTER ANY DATABASE server level permission or CREATE DATABASE in the master database

    For DBCC CHECKDBsysadmin server roles
    WMI accountTo access remote WMI dataAdditional rights on a group that has been given remote access

     

    Need more help? Search the Idera Customer Support Portal.

    Application service comes with SSL already set up. For more information on running the IDERA Dashboard over SSL, see Run IDERA Dashboard over TLS or SSL.



    Scroll Ignore

    Newtabfooter
    aliasIDERA
    urlhttp://www.idera.com
    |
    Newtabfooter
    aliasProducts
    urlhttps://www.idera.com/productssolutions/sqlserver
    |
    Newtabfooter
    aliasPurchase
    urlhttps://www.idera.com/buynow/onlinestore
    |
    Newtabfooter
    aliasSupport
    urlhttps://idera.secure.force.com/
    |
    Newtabfooter
    aliasCommunity
    urlhttp://community.idera.com
    |
    Newtabfooter
    aliasResources
    urlhttp://www.idera.com/resourcecentral
    |
    Newtabfooter
    aliasAbout Us
    urlhttp://www.idera.com/about/aboutus
    |
    Newtabfooter
    aliasLegal
    urlhttps://www.idera.com/legal/termsofuse

    ...