AppManager 8 Database installations pause with an error. (NETIQKB73107)

  • 7773107
  • 22-Jul-2011
  • 22-Jul-2011

Environment

NetIQ AppManager 8.0
Microsoft SQL 2008

Situation

AppManager 8 Database installations pause with an error which contains both 'Ignore' and 'Retry' buttons, attempts to retry result in the same message.

Resolution

In order to get past this error and complete the database installation successfully, you will need to perform the following:

  1. With the error message still waiting for you to select Retry or Ignore, launch SQL Management Studio.
  2. 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.
  3. 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.

Additional Information

Formerly known as NETIQKB73107