Jump to content

How to specify username & password of an external FileMaker data source in a SSS?


Recommended Posts

Hi,

in a SSS on my FMS B, I try to access a password protected FileMaker file that is hosted on FMS A. Using a FM Pro client, I can simply type in the credentials when the script runs. However, accessing it from server B, I have no idea what to do.

This is an excerpt from the event log; not very helpful; but I believe the file cannot be accessed, because it is password protected:

2024-03-09 16:27:58.168 +0100    Information    645    xxx.local    Schedule "mMTag 01:01" scripting error (100) at "FileMaker : MTag : 41 : Perform Find".

What can I do?

Thanks a lot!

 

Link to comment
Share on other sites

@bcooney

I don’t understand how your suggestion applies to the problem, but in any case I don’t want to open jdbc or odbc on that server, just want to access a FileMaker hosted file on another server. Anyway, I’ve found a solution (see below):

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.

(see also here)

Link to comment
Share on other sites

FileMaker server A cannot send data directly to FileMaker server B. This is different behavior than a client connected to two files on different servers. 

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.