How to input user credentials in a FileMaker Server Scheduled Script?

[gczychi]

Hi,

In a FileMaker Server Scheduled Script (SSS), I am trying to execute script steps on a table from another FileMaker Database hosted on a remote machine (see also here). The remote file/databse is of course password protected and in Manage Security, I have allowed to store the user credentials. The remote table is defined as a table occurence in the local Relationships graph.

When I run the script locally in my FileMaker Pro client, during the first script execution, I am asked to type in username and password. From then on, the credentials are stored and the script runs without user interaction.

However, running the same script as a SSS there is no way of providing the user credentials, isn't it?  What can I do to run the script as a SSS? Are there any workarounds?

Thanks a lot for any insights!

G.

 

[gczychi]

OK, I’ve found the solution:

In order to run Server Scheduled Scripts (SSS) that access a remote FileMaker data base, you need to run this script with user credentials of a user that is identical in both databases.

Say, you want to run a SSS on FMS b) and this script accesses tables on FMS a), that are defined as a table occurance in the local relationships graph of b). For this SSS to run correctly, it is necessary that 1) both usernames and passwords in both data bases are identical and 2) that you define this user in the script schedule section of the FMS web interface.

Hope this is helpful for someone.