Page History

...

Installing IDERA SQL Inventory Manager

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

...

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.

Configuring SQL Server

Once the SQL Inventory Manager installation completes, launch SQL Server Management Studio and connect to the cluster environment’s SQL Server Instance where you installed the SQL Inventory Manager Repository.

1. For the SQLInventoryManager  database set its recovery model to "full".
   

   
   
   
2. Create a Full backup for the SQLInventoryManager  database.
   
   
   
3. Under 'Always ON High Availability' go to the availability group you want to use and select Add Database
   
   
   
4. 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.
      
      
      
   4. Once validation finishes successfully click Next.
      
      
      
   5. Check your settings on the Summary section and click Finish to continue.
      
   6. Once the wizard completes click Close.
   7. Go to the Administration tab of SQL Inventory Manager and apply your license.
      
5. Under 'Always ON High Availability' go to the availability group you want to use and select Failover.
   
   
6. On the Fail Over Availability Group dialog click Next and follow these steps:
   1. Select a primary replica and click Next.
      
   2. Connect to the secondary replica and click Next.
      
   3. Check your settings on the Summary section and click Finish to continue.
      
   4. Once the wizard completes click Close.