cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

sysadmin required during installation?

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
By Level 17 Champion
Level 17 Champion

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

View solution in original post

(1) Reply
mfranz
By Level 17 Champion
Level 17 Champion

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