Foxhound 5.0 FAQ
search engine by freefind advanced
Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad           Breck.Carter@gmail.com     


Message: Foxhound:-121;42501;Permission denied: you do not have permission to execute the procedure "sa_server_option"
Message: 121;42501;Permission denied: you do not have permission to execute the procedure "sa_server_option"
Message: Permission denied: you do not have permission to execute the procedure "sa_server_option"

Explanation: This message appears in section 14. Change Target Settings of the Monitor Options page when the user id Foxhound is using to connect to your target database is not allowed to call the sa_server_option() procedure on that database.

One solution is to use a user id with DBA privileges. Another solution is to GRANT SERVER OPERATOR TO that user id on the target database... or, just use dbsrv -zp -zl -zt to start the target database so it's unnecessary to use section 14. Change Target Settings of the Monitor Options page.

If the target database happens to be "Foxhound 5 Adhoc Schema - autostart and connect", note that GRANT SERVER OPERATOR TO ADHOC has not been (and cannot be) executed on that database... so you cannot use section 14. Change Target Settings of the Monitor Options page.

See the Connecting to Target Databases section of the Help.


This page was last updated on September 2, 2019.      Foxhound 5.0 FAQ Home      Foxhound Home      RisingRoad      Breck.Carter@gmail.com