Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Before you install IDERA SQL Inventory Manager, be sure to have:

  • The path to a remote IDERA remote IDERA Dashboard installation. IDERA SQL Inventory Manager integrates with the IDERA Dashboard.
  • A local administrator account on the machine you are installing the product.
  • A host machine for SQL Inventory Manager services.
  • A host SQL Server for the product databases.
  • A service account with permissions to read/write and create databases and update their schemas.
Note

A remote installation only registers IDERA SQL Inventory Manager with a remote IDERA Dashboard, IDERA SQL Inventory Manager is installed in the local computer.

Info

You can also grant IDERA SQL Inventory Manager Product Administrator permissions in the IDERA Dashboard. For more information, see Managing users in the IDERA Dashboard.

Installing IDERA SQL Inventory Manager with a remote IDERA Dashboard

Before you install IDERA SQL Inventory Manager, be sure to meet the requirements mentioned before. Open the installer and follow these steps:

  1. Open On the IDERA SQL Inventory Manager setup, click ProceedSQL Inventory Manager Setup window, click Next to continue with the installation. You can optionally generate a script for generating the SQL Inventory Manager Repository database.
  2. You must verify that the Firewall allows TCP (Transmission Control Protocol) traffic through The ports you want to use. By default, IDERA SQL Inventory Manager uses ports 9275 and 9291 for the Collection and Web Application services respectively.
    To see or edit the default ports SQL Inventory Manager uses click view the list of required ports.
  3. Read the License Agreement. If you agree select , click I accept the Terms and Conditions and click Next to continue.then click Next.
  4. If you want to change SQL Inventory Manager  default installation path, click Browse.
  5. Set a display name for SQL Inventory Manager.
  6. Select Use remote IDERA Dashboard installation Select Remote and provide a Dashboard URL using the format http://<location of IDERA Dashboard>:9292. PORT 9292 is the port for REST services.
  7. Enter the administrator credentials for accessing the remote IDERA Dashboard installation.
  8. Click Next. 
    Image Removed
    Image Added
    To
  9. install SQL Inventory Manager to the default path, click Next. Specify a SQL Server Instance host and a database name for creating the SQL Inventory Manager Repository database.

    By default, the setup program uses your Windows logon account to create and access the Repository database. If you want to use a different path, click Browse.
    Image Removed
    Type a unique name for this instance of IDERA SQL Inventory Manager and click Next.This page allows you to identify each instance of IDERA SQL Inventory Manager or other IDERA products when you have more than one installation of the same product. IDERA recommends that you use a name based on a location or function, such as SIM-Prod or SIM-West. Note that this field accepts only alphanumeric characters (A-Z, a-z, 0-9) and dashes (-).
    Image RemovedMicrosoft SQL Server connection credentials, select Use Microsoft SQL Server Authentication and enter your SQL Server credentials.

    Image Added

  10. Specify the User Name and Password under which the IDERA SQL Inventory Manager services will run and click Next. Use the format <Domain Name>\<User Name> when typing the User Name. IDERA SQL Inventory Manager uses this account for SQL Server connections.
    Image Removed

    Image Added

  11. Click 

    Specify which port you want to use for the Inventory Manager Collection Service. You must verify that the Firewall allows TCP (Transmission Control Protocol) traffic through your specified ports.
    By default, IDERA SQL Inventory Manager uses port 9275  for the Collection service. Click Next to continue.

    Info

    Port values should be between 1 and 65535.

    Keep in mind, that browsers may block some specific ports. To check a list of all blocked ports on Mozilla Firefox, see Mozilla Port Blocking.

    Image Removed
     Specify a SQL Server Instance host and a database name for creating the SQL Inventory Manager Repository database.
    By default, the setup program uses your Windows logon account to create and access the Repository database. If you want to use Microsoft SQL Server connection credentials, select Use Microsoft SQL Server Authentication and enter your SQL Server credentials. Click Next to continue.
    Image Removed
    Click Install if you are ready to start the installation. If you want to review or change any of your installation settings, click Back.
    Image Removed
      Image Added

  12. After the installation is complete, you can select Launch IDERA SQL Inventory Manager to launch SQL Inventory Manager immediately after the installation window closes. Alternatively, you can access IDERA SQL Inventory Manager web application through the following link: http://<ServerName>:9291 where ServerName is the name of the machine on which you installed hosting the remote IDERA ServicesDashboard.
    Image Removed
      Image Added

...

When IDERA SQL Inventory Manager

...

launches on your browser, you should use your Windows user account with your respective password to log in to the product. Please take into account that IDERA SQL Inventory Manager does not store passwords


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

...