Skip to end of metadata
Go to start of metadata

You are viewing an old version of this content. View the current version.

Compare with Current View Version History

« Previous Version 5 Next »

A dedicated SQL Server 2012 (or higher) machine 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 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.

  • No labels