If you simply want the users to access the databse you don't need a VPN. (You would for other functions, if the database has records that link to other files, such as container fields with referenced documents in them, for example.)
You need to set up your host network's router for port forwarding. You need to forward Port 5003 to the host computer. The remote users should use Open Remote - Favourites ->Add a Favourite and enter the public IP address of the host network's router.
Thanks for your feedback!
As a matter of fact I tried that. I configured port forwarding and added public IP to favorites and it automatically showed a list of available files. However, after selecting any of them and attempting to login we are getting error “The account or password you entered cannot be used to access this file”.
Any help is welcomed. Thanks you so much!
Try that same account name and password from inside the network. Check that caps lock etc is not on. Once you see the files listed then you should have access.
Are you by any chance using server side authentication instead of Filemaker acocunts and passwords here?
We've tried different users, passwords, etc - no luck. These files look weird. Something is telling me, these are configuration files or something, not actual DB files. Not sure though... Any thoughts?
Hi PhilModJunk, I'm not very familiar with using server side authentication but know that all LAN users need to enter username and password for login.
When you use the 'Open Remote' you should see a list of servers on the left side. Do you see the server that is hosting the file you mean to log on to?
When you click on the correct server you should see in the right pane all of the FM files that is is hosting. Do you see the correct file name there?
Sorbsbuster, this is exactly what I am seeing. After selecting a host and picking up some file from a list I hit open, then after providing user credentials I am getting an error “The account or password you entered cannot be used to access this file”.
I have contacted the guy who primary installed and setup FileMaker for us locally and here is his reply:
"The database is setup to use a opener file on the local machine that runs scripts to configure individual user settings each time it opens the database. The file - open remote procedure might be something we could use to test performance of the database over a VPN though."
I am confused by your postings:
"These files look weird. Something is telling me, these are configuration files or something, not actual DB files."
then, to the question:
"Do you see the server that is hosting the file you mean to log on to? [...] Do you see the correct file name there?"
"this is exactly what I am seeing."
I don't know whether you are seeing the correct file names or not. Do you see the same file names when you use Open Remote from inside the network?
You do not need a VPN to make the file open, or available for opening. (There are other features which may require a VPN.)
You should be able to use a valid user account and password to open the file IF you can see the correct host in the left pane and the correct filename in the right pane. I cannot think of anything that an 'opener' file would do more. Yes - it can make it easy for you to double-click and open the file for you, but it will just be doing silently what you are doing here, step-by-step.
I am seeing all files and they seem to be correct files (sorry for the confusion). I just verified folder of database listed at the FileMaker Server Admin and these are same files as I see after adding public IP to my favorite hosts. But I cannot open them for some reason. Can it be some sort of configuration at FileMaker Server? Maybe I have to enable somewhere to be able to use and modify these DBs remotely??? I am not sure .... What do you think? Thanks for your help!
Can you open these files using 'Open Remote' from inside your network (using that account name and password)?
Nope. I am getting same authentication error. (The account or password you entered cannot be used to access this file).
"The database is setup to use a opener file on the local machine that runs scripts to configure individual user settings each time it opens the database.
Are you using these "opener files"?
I suspect that they use a password to open the files on the network. Their external data source references in these opener files may or may not work from a remote location as they might use an IP address valid for inside the network that is not valid for remote access from outside the network.
Any chance you can work with the guy that set this up originally to resolve this?
Seems like he would be your best bet here as he should know how he set this up in the first place.