Oninit
Talk to an expert →

Informix Error -27010: Only an administrative user can connect in administrative user mode.

Cause and resolution

Only an administrative user can connect in administrative user mode.

The database server is in administrative user mode. You must set the ADMIN_USER_MODE_WITH_DBSA parameter to '1' to allow any administrative user to connect. If the ADMIN_USER_MODE_WITH_DBSA parameter is set to '0', then only user "informix" or the non-root server owner can connect.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-27010 fires when a non-administrative user tries to connect while the database server is in administrative user mode — per the official guidance.

  1. A non-administrative user connecting while ADMIN_USER_MODE_WITH_DBSA is 0, per the official guidance — only user informix or the non-root server owner can connect in that case.
  2. A non-administrative user connecting regardless of ADMIN_USER_MODE_WITH_DBSA, per the official guidance, if the parameter isn't set to 1 to allow any administrative user.
Solutions / Resolution
  1. Set ADMIN_USER_MODE_WITH_DBSA to 1, per the official guidance, to allow any administrative user to connect, or
  2. Connect as informix or the non-root server owner, per the official guidance, if ADMIN_USER_MODE_WITH_DBSA is 0.
Examples
N/A

No specific triggering statement is documented beyond a non-administrative user connecting in administrative mode.

Diagnostic Checks
  1. Check the ADMIN_USER_MODE_WITH_DBSA ONCONFIG parameter's value, and connect with the appropriate user for its setting.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -27010 in this set yet.

A non-administrative user tried to connect while the server was in administrative user mode — connect as informix/the server owner, or set ADMIN_USER_MODE_WITH_DBSA to 1.