Some users may have issues creating a community account. For more information, please click here.

JanPie
Intrepid explorer

sysadmin required during installation?

Jump to solution

Hi Everyone,

Recently I did fresh test installation of FNMS and stumbled into an issue while configuring db.

Even though account had db_owner role assigned, db configuration process failed at OpJobs.sql step (as per the screenshot). Service account used for installation was temporarily assigned a sysadmin rights to work around this and completed installation.

However, I’d like to know if this is normal behavior and if there is a way to avoid this.

Official installation guide only mentions db_owner is required, but that doesn’t seem to reflect reality.

Just few more details:

  • Databases are already created by DB team at the time of installation
  • DBs settings are aligned with requirements
  • Service account has db_owner role

Kind regards,

Jan

1 Solution
mfranz
Trusted advisor

Hi Jan,

Yes, this is normal behaviour. If you look at the SQL statement closely, you'll see that it only tries to remove agent jobs.

2019-09-02_11h13_27.png

I usually just remove that abstract from the scripts, if my rights are insufficient.

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post

1 Reply
mfranz
Trusted advisor

Hi Jan,

Yes, this is normal behaviour. If you look at the SQL statement closely, you'll see that it only tries to remove agent jobs.

2019-09-02_11h13_27.png

I usually just remove that abstract from the scripts, if my rights are insufficient.

Best regards,

Markward

Softline Group is Europe's leading independent expert in Software Asset Management.

View solution in original post