Page History

This section guides you through the installation of IDERA SQL Inventory Manager.  You You can install IDERA SQL Inventory SQL Inventory Manager on any computer that meets or exceeds the the product requirements.  

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

• The IDERA Dashboard installed. 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 host SQL Server for the product databases.
• A service account with permissions to read/write and create databases and update their schemas.

...

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

1. On the
Welcome to the
2. IDERA SQL Inventory Manager Setup
Wizard
3. window, click
Next to
4. Proceed to continue with the installation.
   
Image Removed Click I accept the terms
5. Image Added
6. Read
in
7. the License Agreement. If you agree, click I accept the Terms and Conditions and then
click 
8. click Next.
   
Image Removed
9. On the Destination Folder page, click Next to install to the default folder or click Change to select the directory where you want to install IDERA SQL Inventory Manager. Click Next to continue.
   Image Removed
10. On the IDERA Dashboard location and credentials page, specify:
    • the URL of the IDERA Dashboard
    • the IDERA Dashboard Administrator User Name
    • the IDERA Dashboard Administrator user account Password
    Use the format <Domain Name>\<User Name> when typing the administrator credentials. IDERA SQL Inventory Manager uses this account when accessing the IDERA Dashboard to share data.
    Image Removed
11. Click Next to continue.
On the IDERA Dashboard Display Name page
12. Image Added
13. If you want to install IDERA Dashboard locally, choose local and click Next. If you want to register SQL Inventory Manager with an existing remote IDERA Dashboard installation, choose Remote and follow these steps .
    Image Added
14. If you want to change SQL Inventory Manager and IDERA Dashboard default path, click Browse.
    On the Display Name box, type a unique name for this instance of IDERA SQL Inventory Manager
,
15. and
then
16. click Next.
This page
17. A Display Name 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
SQLInventoryManager
18. SIM-
Production
19. Prod or
SQLInventoryManager
20. SIM-
US
21. West. Note that this field accepts only alphanumeric characters (A-Z, a-z, 0-9) and dashes (-).
    
Image Removed
22. Image Added
On the IDERA SQL Inventory Manager Service Account page, specify the User Name and Password, under which the services will run, and then click Next. Use the format 
23. Specify a User Name and a Password for the Service Account for IDERA Dashboard. Use the format
24. <Domain Name>\<User Name>
when typing the User Name
25. . IDERA SQL Inventory Manager uses this account to connect, discover, and gather configuration information from SQL Servers.
 The
26. The installer grants the "Log on as a Service" right to the account that you specify. Click Next to continue.
    If you want to use different credentials for the Service Account for SQL Inventory Manager, clear the Use the same as above box, and type your credentials. IDERA SQL Inventory Manager uses this account when accessing the IDERA Dashboard to share data.

Image Removed
27. 
    Image Added
28. Specify a SQL Server Instance host and database names for the creation of the SQL Inventory Manager Repository database and the IDERA Dashboard Repository database respectively.
    By default, the setup program uses your Windows logon account to create and access the Repository databases. If you want to use Microsoft SQL Server connection credentials, select Use Microsoft SQL Server Authentication and click Change to enter the SQL Server credentials. Click Next.
    Image Added

29. Determine

On the Service Ports section, determine

30. which ports you want to use for the

IDERA SQL

31. Inventory Manager Collection Service and for the

Web Application Service

32. IDERA Dashboard services. You must verify that the Firewall allows TCP (Transmission Control Protocol) traffic through your specified ports.
    By default, IDERA SQL Inventory Manager uses ports 9275 and

9276

33. 9291 for the Collection and Web Application services respectively.

Click 

34. Click Next.

    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 

35. Image Added

36. Click Install if
37. On the IDERA SQL Inventory Manager Repository Database page, specify the host SQL Server instance where IDERA SQL Inventory Manager will create the Inventory Manager and Core databases and type their respective names. These databases store collected data, alert information, and alert configuration settings.
    By default, the setup program uses your Windows logon account to create the Repository databases, but you can also choose to use Microsoft SQL Server connection credentials by checking the option Use Microsoft SQL Server Authentication. When you choose this option, a new window automatically opens, type the respective SQL Server login and password.
    The user who installs IDERA SQL Inventory Manager has access to the product. If you need other users to have access to IDERA SQL Inventory Manager, you can grant them access from inside the product after the installation is complete. Click Next.
    Image Removed
On the next section, click Install if
38. you are ready to start the installation. If you want to review or change any of your installation settings, click Back.
    
Image Removed
39. Image Added
40. After the installation is complete,
click Finish. You can check the box for launching IDERA SQL Inventory Manager immediately after installation
41. 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:
 
42. http://<ServerName>:
9276
43. 9291 where ServerName is the name of the machine on which you installed the IDERA SQL Inventory Manager services.
    
Image Removed
44. Image Added

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