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 4 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. 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.

Now that the pre-requisite services and SQL server have been set up, you are now ready to install Enterprise Commander.

  • No labels