Page History

...

1. On the IDERA SQL Inventory Manager Setup window, click Proceed to continue with the installation. Image Removed
2. Read the License Agreement. If you agree, click I accept the Terms and Conditions and then click Next.
   Image Removed
3. 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 Removed
4. 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 and click Next. 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 SIM-Prod or SIM-West. Note that this field accepts only alphanumeric characters (A-Z, a-z, 0-9) and dashes (-). Image Removed
5. Specify a User Name and a Password for the Service Account for IDERA Dashboard. Use the format <Domain Name>\<User Name>. IDERA SQL Inventory Manager uses this account to connect, discover, and gather configuration information from SQL Servers. 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
6. On the SQL Inventory Manager Repository section,  Specify a cluster node for the creation of the SQL Inventory Manager Repository database.
   Select Use Microsoft SQL Server Authentication and click Change to enter the SQL Server credentials for the specified clustered node. Click Next. Image Removed

7. Determine which ports you want to use for the Inventory Manager Collection Service and for the 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 9291 for the Collection and Web Application services respectively. 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

8. 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
9. 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 the IDERA SQL Inventory Manager services.
   Image Removed

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.

Installing Inventory Manager and IDERA Dashboard on an AG

Configuring SQL Server

After installing SQL Inventory Manager, follow this instructions to configure.... 

...

SQL Server

...

1. Launch SQL Server Management Studio and connect to the cluster environment’s SQL Server Instance where you installed the SQL Inventory Manager Repository.

2. Open the properties dialog for the SQLInventoryManager  database and set its recovery model to "full".
3. Create a Full backup for the SQLInventoryManager  database.
4. Under 'Always ON High Availability' go to the availability group you want to use and select Add Database
5. On the Add Database to Availability Group dialog click Next and follow these steps:
   1. Select the SQLInventoryManager  repository database and click Next.
   2. Select Full data synchronization and click Next.
   3. Connect to all secondary nodes and click Next.

1. Go to ‘Always ON High Availability’, and under ‘Availability Group’, Select “Add Database..”

...

Go to the “Options” tab from the Left hand side and set the Recovery model to “Full”

...

Registering License

...