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:
Kind regards,
Jan
‎Aug 29, 2019 07:02 AM
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.
I usually just remove that abstract from the scripts, if my rights are insufficient.
Best regards,
Markward
‎Sep 02, 2019 04:14 AM
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.
I usually just remove that abstract from the scripts, if my rights are insufficient.
Best regards,
Markward
‎Sep 02, 2019 04:14 AM