Remote Servers in Filemaker Pro 9 on Windows 7 Clients

With Windows XP now pretty much impossible to get preloaded on new machines, our clients are finally moving to Windows 7 as their hardware refreshes.

A segment of our clients uses an application built upon Filemaker Pro, and they’re running  v9.03 which isn’t the most Windows 7 friendly version of Filemaker (that honor is reserved for any of the versions released in the last 3 years).  As we roll out Windows 7, we have found that databases hosted on remote servers don’t show up in their Open Remote… dialog box.  The server appears, but the available databases do not populate.

Finally, after much searching, we have found the answer, thanks to a thread over at Filemaker Today forums which suggests copying the SERVER.PEM file out of a working machine’s Filemaker Pro directory and copying it onto the failed machine will solve the issue, and lo and behold, we can confirm that does indeed work.

Thanks, Internets!

Resetting the Admin Password in Filemaker Server 9 on Windows

Long story short, you can’t… at least not thru the interface. Instead, you need to totally blow out your configuration and reconfigure the server.

However, it’s not as bad as it seems – there’s not so much to configure that it should be too big of a hassle.

If you have console access, close your databases, and make note of your settings.

  • Stop the Filemaker Service.
  • Assuming a default installation, go to c:\program files\filemaker\filemaker server\admin\conf and delete the 4 XML files in there.
  • Restart the Filemaker Service
  • Reconnect to the Filemaker Console

It’ll re-walk you thru the wizard to set up the server, and the first thing you do is set up a username and password. Your databases (again, assuming a default installation) will already be there, ready to go…