Environment
NetIQ AppManager 6.x
NetIQ AppManager 7.0.x
NetIQ AppManager 7.0.x
Situation
Running Discovery_SQL and getting the following error message: 'SQL discovery is not applicable'
Resolution
Save the SA password for the particular SQL server with the "Save SQL password" mechanism by doing the following:
- Go into the AppManager Operator Console .
- Pull down the "Extension" menu.
- Select "Save SQL password".
- Select the appropriate computer name.
- Enter sa as the SQL login.
- Enter the SQL password appropriately.
- Click on Save.
- Go into AppManager Security Manager.
- Select the SQL server computer name which returns the error upon discovery of SQL.
- Click on the SQL tab.
- Enter the SQL sa password.
- Click logon.
Cause
The sa account password was not yet saved into the repository for the discovery script to pull.
Additional Information
Formerly known as NETIQKB2775
After installing the SQL Managed Object [MO] the Discovery_SQL Knowledge Script is automatically kicked off.
After saving the SQL sa password, re-run the Discovery_SQL Knowledge Script on the same SQL server.
After installing the SQL Managed Object [MO] the Discovery_SQL Knowledge Script is automatically kicked off.
After saving the SQL sa password, re-run the Discovery_SQL Knowledge Script on the same SQL server.