KBI 310083 The Argent SNMP Monitor Installer Crashes If Not SQL DB Owner

Version

Up to 0804

Date

20 Sep 2007

Summary

The Argent SNMP Monitor installer crashes if not SQL DB owner

Technical Background

The installer for the Argent SNMP Monitor crashes in ARGENT_SETUP2.EXE if all of the following conditions are true:

  • SQL Server is chosen as backing database
  • The credentials used for database access are not the creator of the database (even though they may be given db_owner access of that database)
  • The credentials used for database access do not have a Server Role of sysadmin

All other products in the Argent Extended Technology suite can be installed successfully with this configuration.

Resolution

A workaround is to delete the Argent database and recreate it using the credentials desired for database access by Argent. This requires a complete reinstall of the Argent product suite.

Another workaround is to grant the relevant user the “sysadmin” Server Role, though this may not be desired for security reasons.

This issue is corrected in 0804 production release.