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 2012 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_BIN for the system database.
SQL Server collation Latin1_General_BIN for the M3 Business Engine database.
A static port for each instance.
Database Engine Services
Client Tools Connectivity
Management Tools - Basic
Management Tools - Complete
SQL Management Tools can only be installed on a Windows Server 2012 with full GUI interface configuration.
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.
Do not enable FILESTREAM for Transact-SQL access in the FILESTREAM tab.