Content Comparison

...

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. Create In the ER_COMMANDER database create a schema called 'ENGINEROOM'.
4. 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) .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.with all the settins 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.