A dedicated or pre-existing SQL server will have to be commissioned/made available to host Windows 2012 (or higher) 64 bit server running SQL Server 2012 (or higher) will need to be setup and configured to store the Enterprise Commander data. This The server will need to be a SQL Server 2012 or higher and will need to be set up configured with:

• Mixed mode authentication
• Local account with privileges to create a DB and read and write to that DB

SQL Server Schema set up

The Schema to host the Enterprise Commander data will need to be set up as follows:

...

Follow the steps below to prepare SQL for Enterprise Commander:

1. Launch SQL Server Management Studio on your SQL Server machine.
2. Login using a database account that has database creation privileges.
3. Create a new Database called ER_COMMANDER and leave the Owner as <default>.Create a schema called 'ENGINEROOM'.
   
   1. Right Click on the Databases folder and select New Database
   2. Set the Database name to ER_COMMANDER
   3. Do not set anything else and click OK
4. Expand the ER_COMMANDER database folder to create a schema. 
   1. In the ER_COMMANDER
   database create a new user for the database called ER_USER (note: this user is different to the ER_USER created to log into the SQL server).
5. Map the Database user ER_USER to the SQL login user ER_USER and assign the default schema as 'ENGINEROOM'. On the Membership view, select dbo_owner.
6. 1. folder; right-click the Security folder, point to New and select Schema
   2. In the Schema - New dialog box enter ENGINEROOM for the schema name, then click OK. Do not set schema user.
7. Create a SQL Server account (not a Windows or Active Directory account) which will be used to login to the server.
1. Right Click the top-level Security folder, point to New and select Login
2. Select SQL Server Authentication
3. Set the Login name to ER_USER and choose a password
4. Uncheck User must change password at next login
5. Optionally Uncheck Enforce password expiration, Enforce password policy
6. Select the Server Roles page. Only "public" should be selected.
7. Select the User Mapping page.
8. Tick the Map box next to the ER_COMMANDER database.
9. Type in ENGINEROOM in the Default Schema field. Do not press enter.
10. In the Membership page select db_owner.
11. Click OK

Now that the pre-requisite services and SQL server have been set up, you are now ready to install Enterprise Commander.After the SQL server has been set up, proceed to  Enterprise Commander Installation.