It is recommended to perform Windows Update to enhance the SQL Server security and performance before running the installation.
Ensure that you have your Microsoft SQL Server 2016 SP1 installation media, installation key, and operating system installation media.
Log on using an account that has Administrative rights.
Disable any Antivirus software that is running as it can sometimes affect the installation.
Shut down any services or applications that depend on SQL Server, Data Source Names (DSN), or Open Database Connectivity (ODBC).
Close any unnecessary applications that access the registry.
Close the Event Viewer.
M3 BE SQL Server Instance Requirements
Mixed mode authentication.
SQL Server collation Latin1_General_BIN2 for the system database.
SQL Server collation Latin1_General_BIN2 for the M3 Business Engine database.
A static port for each instance.
Database Engine Services
SQL Server Management Tools is no longer installed from the main feature tree and must be downloaded separately.
In the Collation tab, choose Latin_General (Latin_General_BIN2) binary sort for Database Engine, and click Next.
Specify the sa login password.
Always use a strong password for the sa account and change the password periodically.
Add a (current) User as SQL Server administrator.
Accept or change data directories in the "Data Directories" tab.
In the TempDB tab, accept default values or configure the tempdb by following the recommendations in the M3 Business Engine and Microsoft SQL Server - Best Practices, version for M3 BE 15.1 and Microsoft SQL Server 2016 in Infor Xtreme Documentation.
Do not enable FILESTREAM for Transact-SQL access in the FILESTREAM tab.