Environment
NetIQ AppManager 8.0
Microsoft SQL 2008
Situation
Resolution
In order to get past this error and complete the database installation successfully, you will need to perform the following:
- With the error message still waiting for you to select Retry or Ignore, launch SQL Management Studio.
- Manually change the dbo of the QDB/CCDB to be a different user than the one you defined in the earlier steps of the installation.
- Once that is done, you can press 'Retry', and the installation should continue without further error, and should complete successfully.
Cause
Both SQL and the AM Repository or Control Center Database were installed using the same account.
By default, in SQL 2000 the Model database contains the name of the user that installed SQL Server. So when the QDB or NQCCDB are created they are created with all the users of the model database ? which will include the user that installed SQL. If during the install the user chooses to make the user that installed SQL the database owner then we will have this failure.
This issue is limited to SQL 2008 only, and does not affect AppManager 8.0 QDB or CCDB installations on SQL 2008 R2.