Ezy Systems runs on Microsoft SQL Server. If you're installing SQL Server on the same machine as Ezy Systems, or on another server on the same network, follow the configuration steps below to ensure the instance performs well and has the correct permissions in place.
Step-by-step instructions
1. Select the correct features during installation
During SQL Server setup, use the standard installation and untick Machine Learning Services and Language Extensions (including R, Python, and Java). Removing these improves performance, as Ezy Systems doesn't use them.
Also ensure the following are selected:
- Database Engine Services
- SQL Server Replication
- Full-Text and Semantic Extractions for Search
- Data Quality Services
2. Set the maximum server memory
Open SQL Server Management Studio, right-click the server instance and select Properties, then go to Memory. Set Maximum server memory (in MB) according to your standard configuration and the resources available on the server.
Tip: Leave enough memory headroom for the operating system and any other applications running on the same server.
3. Set the remote query timeout to 0
Still in Server Properties, go to Connections and set Remote query timeout (in seconds) to 0 (no timeout). Confirm Allow remote connections to this server is ticked.
4. Grant sysadmin rights to the appropriate group
In Object Explorer, expand Security > Logins, right-click the relevant login or group and select Properties, then go to Server Roles. Tick sysadmin for the group that will manage the Ezy Systems database.
5. Set database permissions for standard users
For standard (non-admin) users, open their Login Properties and go to User Mapping. Select the appropriate Ezy Systems database, then tick db_datareader and db_datawriter under Database role membership.
Note: Only grant sysadmin to the group responsible for managing the server. Standard users should be limited to db_datareader and db_datawriter on the relevant database only.