Versions Compared

Key

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

...

  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 settins 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

...