A dedicated 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. The server will need to be 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

Follow the steps below to configure the schema for Enterprise Commander:

1. Create a SQL Server account (not a Windows or Active Directory account) which will be used to login to the server called ER_USER.
2. Create a new Database called ER_COMMANDER and leave the Owner as <default>.
3. In the ER_COMMANDER database create a schema called 'ENGINEROOM'.
4. In the ER_COMMANDER database create a new user for the database (note: this user is different to the ER_USER created to log into the SQL server) with all the settings below:
   1. User type: SQL user with login
   2. User name: ER_USER
   3. Login Name: ER_USER
   4. Default schema: ENGINEROOM
   5. In the Membership page select db_owner

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