---
title: MS SQL Settings for Pro Migrations
description: How to set up Microsoft SQL for pro migration
---
[Skip to content](https://knowledge.ezysys.com.au/pro-support/sql-set-up-for-pro-migrations-#main-content)
English - Australia
Show submenu for translations
- Home
- Products
- Pricing
- Blog
- Company
Open main navigation
Close main navigation
- Home
- Products
- Pricing
- Blog
- Company
- English - Australia
Show submenu for translations
- Contact us
Contact us
How can we help you?
- There are no suggestions because the search field is empty.
1. [Pro Support Centre](https://knowledge.ezysys.com.au/pro-support?hsLang=en-au)
2. [Pro Migration](https://knowledge.ezysys.com.au/pro-support/pro-migration?hsLang=en-au)
# MS SQL Settings for Pro Migrations
## This article covers how to configure Microsoft SQL Server, on the same server as Ezy Systems or elsewhere on the same network, for an Ezy Systems installation. Important: These steps are intended for IT administrators setting up a new SQL Server instance for Ezy Systems. Complete them before installing or migrating the Ezy Systems database.
**Overview**
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.
**MS SQL Server requirements are based on database size & current Windows Server.**
Where the windows server is 2019 or later, please install **MS SQL 2025 Express** version as it will cater up to 50GB of data for free.
Please note All earlier Express versions only cater up to 10GB and can be insufficient in some circumstances. If unsure, please reach out to the Ezy support Team.
**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 does not require them.
Also ensure the following are selected:
- **Database Engine Services**
- **SQL Server Replication**
- **Full-Text and Semantic Extractions for Search**
- **Data Quality Services**
- ****
### 2. SQL Server Authentication set to Mixed Mode
### 3. SQL Server Collation set to Latin1\_General\_CI\_AS
### 
### 4. Windows Users SQL Server Access
Window users which require access to the Ezy Application must be added as logins to the SQL Server, with the db\_datareader/writer roles in the article.
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**.
### 5. Windows Users Copy live data to test access
Windows Users which require the ability to copy a test database must be granted dbowner and dbcreator roles.
### 6. 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.
**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.
### 7. 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.
### 8. 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.
If you have any questions regarding installation, please contact the Ezy Systems Support Team
- [FAQs](https://knowledge.ezysys.com.au/pro-support/faqs?hsLang=en-au)
- [Troubleshooting](https://knowledge.ezysys.com.au/pro-support/troubleshooting?hsLang=en-au#main-content)
- [Email](https://knowledge.ezysys.com.au/pro-support/troubleshooting?hsLang=en-au#email)
- [General](https://knowledge.ezysys.com.au/pro-support/general?hsLang=en-au#main-content)
- [Search & Navigation](https://knowledge.ezysys.com.au/pro-support/general?hsLang=en-au#search-navigation)
- [Payroll](https://knowledge.ezysys.com.au/pro-support/payroll?hsLang=en-au)
- [Winemaking](https://knowledge.ezysys.com.au/pro-support/winemaking?hsLang=en-au#main-content)
- [Bulk Wine Management](https://knowledge.ezysys.com.au/pro-support/winemaking?hsLang=en-au#bulk-wine-management)
- [Creditors](https://knowledge.ezysys.com.au/pro-support/creditors?hsLang=en-au#main-content)
- [Creditor Payments](https://knowledge.ezysys.com.au/pro-support/creditors?hsLang=en-au#creditor-payments)
- [Pro Migration](https://knowledge.ezysys.com.au/pro-support/pro-migration?hsLang=en-au)
- Home
- Products
- Pricing
- Blog
- Company
[](http://www.ezysystems.com.au)
[mailto:email@email.com](mailto:email@email.com)
Copyright © 2026, Ezy Systems