RPM technical requirements for SQL Server
RPM Server requirements
The “RPM Server” files can be installed on either a Windows server or Windows 10/11 workstation and require approximately 500 MB of disk space.
RPM Client requirements
The RPM Client can be run on a Windows 10/11 workstation or on a remote desktop on a Windows server that supports remote desktops or remote apps. Workstation requirements include:
• Windows 10 or 11
• 4 GB RAM minimum
• 3 GB disk space
• 1366 x 768 minimum screen resolution with 100% text size
The RPM Client uses Microsoft Access Runtime 365. However, you do NOT need to have Office installed to run RPM. If you have Office 2016 or later installed including Access, RPM will use your version of Access. Otherwise, RPM will install the Access 365 runtime. RPM Client machines need to be up-to-date on any Windows and Office updates from Microsoft.
Network requirements
RPM can run using a client/server network or a peer-to-peer network for smaller numbers of users. Users must have ALL rights to the “RPM Server” folder, regardless of whether it is installed on a server or workstation.
The RPM server and RPM Client must be run on the same local area network (or both can be run on the same Cloud server). The RPM Client cannot be run over the internet using a VPN, but it can be run using a remote desktop/remote app on the same network as the RPM server.
The RPM Client can be installed from the server using either a drive mapping (F:\RPM Server) or a UNC Path (\Server\RPM Server). Due to security issues with Office trusted locations, we do NOT recommend installing the RPM Client from the server using an IP address (such as \\10.1.1.1\RPM Server).
You should NOT use any wireless connections to connect an RPM Client workstation to your RPM server computer. All network connections should use wired connections.
SQL Server requirements
If you have an RPM license to use a SQL Server database instead of an Access database, RPM supports SQL Server versions 2016 through 2022. Your IT department will need to acquire and install the SQL Server software before RPM can be installed. RPM will work with SQL Express, but that should only be used for smaller installations.
If the SQL Server is on a cloud server, the RPM server and RPM Client must be run on the same cloud network. The RPM server and RPM Client cannot be run on a local area network using a Cloud SQL Server.
The SQL Server must be configured for SQL Server and Windows Authentication mode. Each RPM database uses a user ID and password for the SQL database connection that can be configured by your IT department.