Skip links

FileMaker Server on the web: It's that easy.

FileMaker training, courses, coaching

FileMaker is a very scalable database system that can easily be used by several hundred users at the same time. If more than ten users are to work with a FileMakerDatabase work, as a rule a FileMaker Server in the respective company. But what happens if the database is to be accessed from several locations? In this case, there are basically two solutions.

If the FileMaker Server is to remain physically in the company, access to the company'sNetwork via a secure VPN tunnel. However, as FileMaker generates a lot of network traffic due to a very large overhead, working directly on the database via a VPN tunnel is usually very slow. Alternatively, a workstation located in the company can be accessed via Remote Desktop, for example. This method is usually more performant, as FileMaker is then executed on the computer in the company and only the screen information is transferred to the remote computer via Remote Desktop.

Another option for access from anywhere in the world is to install a FileMaker Server on a web server. In this article, I will show you the advantages and disadvantages of this solution and how you can install it.

Before we get to the practical part of the installation, a few thoughts on running FileMaker databases on a web server. FileMaker Pro Server or Advanced is currently available for Microsoft Windows or Apple Mac OS X. The web server to be used must therefore run under one of these two operating systems - a Linux server, which is otherwise common on the web, is therefore out of the question - unless a virtual Windows environment is made available on the Linux server, e.g. via VMware. In this article, I describe the installation on a Windows web server, as offered by many hosting providers such as 1&1 or Hosteurope. Depending on the complexity of the database and the number of connected users, a virtual server may also be sufficient, which is usually cheaper to maintain than a dedicated server. Since Windows servers are much more common among hosting providers than servers under Mac OS X, my article deals with the installation of a FileMaker Pro server on a web server under Microsoft Windows.

To install a FileMaker Server on a web server, you first need a web server that runs under Windows or Mac OS X. You can rent one from 1&1 or Hosteurope, for example, for monthly fees starting at around 15 euros.

If your web server has been fully set up by your hosting provider, you first need the address of the server (IP address) and the access data for a remote desktop session. In our example, we assume the following data:

IP address: 190.190.190.190, user name: Administrator, password: FMServerPass

First login to the web server via remote desktop connection

The "Remote Desktop Connection" program is already installed on Windows - you can simply start it from the Windows Start menu. If you are working with a Mac, download the Remote Desktop Connection (RDV) program from Microsoft.

Now start the Remote Desktop Connection program on your PC or Mac. A window will appear in which you enter the access data for your server:

Once you have entered all the data in the configuration window for the remote desktop connection, click on the [Connect] button. If all parameters are correct, you will land on the Windows desktop of your new web server a short time later.

Setting up FTP on your web server

Next, you need to transfer the "FileMaker Pro Server" software to your web server so that you can install it there. For this purpose, you need FTP access to your server. You can set this up by opening the following program:

Start > Programs > Administrative Tools > Internet Information Services (IIS) Manager

Now open your server in the left-hand column and then click on the "FTP sites" area. The "Default FTP site", which has usually already been created by the hosting provider, now appears in the right-hand area.

If the FTP service is stopped, right-click on the default FTP site and select [Start] from the context menu that appears. The FTP service is now started and you can now access your web server with any FTP program.

Transferring from FileMaker Pro Server to the web server via FTP

Now start an FTP program of your choice on your computer. On a Mac, for example, you can use the free program Cyberduck, on Windows, for example, CoreFTP. If you do not yet have an FTP program, you can download one from http://www.versiontracker.com for Windows or Mac OS X, for example. Now create a new connection to your web server in your FTP program. Enter the following as Host (Server), enter the IP of your web server as the user name, your chosen user name (Administrator) and your password. If necessary, set the port to 21 and select passive transfer mode. Once you have entered all the data, you should now be able to connect to your web server via FTP without any problems.

If the connection via FTP works, place your FileMaker Pro Server CD in your drive and copy all the required installation files to your web server. Depending on the speed of your Internet connection, this process may take some time.

Installation of FileMaker on the web server

Once the installation files have been successfully transferred, reconnect to your web server using the remote desktop connection. On a normally configured Windows server, the transferred files are located in the directory:

C:Inetpubftproot

Now start Setup.exe to install FileMaker Pro Server on your web server. The installation process is identical to the one you are used to on your desktop computer.

When the installation of FileMaker Pro Server has been completed, you must now release the ports for FileMaker in the Windows firewall. To do this, open the Control Panel and double-click to open the Windows Firewall settings.

In the Windows Firewall settings, click on the [Exceptions] tab. The following four ports must now be added by clicking on the [Add Port] button:

  • Port 50003, TCP
  • Port 50006, TCP
  • Port 5003, TCP
  • Port 5003, UDP

Once all ports have been added, you can start transferring your desired FileMaker database(s) to your server via FTP. As soon as you have transferred the databases via FTP, copy them to the database directory of your FileMaker server. In a standard installation, this can be found in the following location:

C:Program FilesFileMakerFileMaker ServerDataDatabases

Once you have copied your databases to the directory mentioned, you can start the FileMaker Server on your web server. To do this, open FileMaker Server Admin, which was placed on the Windows desktop during the installation of FileMaker Server.

Don't forget to configure the FileMaker server according to your wishes, assign an administration password and create a backup of your databases. I also recommend that you stop the FTP service when not in use and, if necessary, close all unneeded ports in the Windows firewall. For a web server under Windows, it is also advisable to use a virus scanner and to install Windows updates regularly. However, if possible, switch off the automatic installation of Windows updates so that the web server does not install updates on its own and close your databases abruptly due to any necessary restarts.

What do I need to know about FileMaker on a web server?

With the instructions described in this article, you should be able to install your FileMaker databases on a web server. This basically works very well and is relatively easy to implement. Remember, however, that you have significantly less network bandwidth available via the Internet than in the local network. As a rule, this mainly affects write access, i.e. the upload of data. The less your databases are burdened with "graphical bells and whistles", the better they will perform on a web server. If you are only at the beginning of a FileMaker project that will later run on a web server, it is best to implement the database in such a way that data-intensive elements such as graphics for the user interface etc. are stored in a local database, so that only the dynamic text data is stored on the web server.

I hope that my instructions have helped you to install a FileMaker Server on a web server without any problems. If you have any questions or problems during the installation, please do not hesitate to contact me.

Leave a comment

Share this page:

ERP software as flexible as your company.
We will be happy to advise you.

Customizable ERP software for Mac, Windows and iOS.

You are here: Setting up a FileMaker server on the Internet as a web server. So you can access your FileMaker database anywhere | goFileMaker