Versions Compared

Version Old Version 3 New Version 4
Changes made by

Peter Davis (Unlicensed)

Pramuk Shyam Pathy (Unlicensed)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

  1. Create an a SQL Server account (not a Windows or Active Directory or local user 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 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).
  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.

...