...
- Create a SQL Server account (not a Windows or Active Directory account) which will be used to login to the server called ER_USER.
- Create a new Database called ER_COMMANDER and leave the Owner as <default>.
- In the ER_COMMANDER database create a schema called 'ENGINEROOM'.
- 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:
- User type: SQL user with login
- User name: ER_USER
- Login Name: ER_USER
- Default schema: ENGINEROOM
- In the Membership page select db_owner
...