KBI 220742 Installer Terminates Prematurely If Not SQL DBOwner

Version

Argent SNMP Monitor 8.0A-0707D

Date

20 September 2007

Summary

Argent SNMP Monitor Installer Terminates Prematurely If Not SQL DB Owner

Technical Background

The installer for the Argent SNMP Monitor terminates prematurely 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 can be installed successfully with this configuration.

Resolution

An Issue Report has been logged, and this will be resolved in a future release.

A workaround is to delete the database and recreate it using the credentials desired for accessing the database. This requires a complete reinstall of the Argent Extended Technology.

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