Creating Granta MI SQL logins

Depending on your preferred Microsoft SQL Server access management mode, one or more SQL logins must be created in SQL Server Management Studio to allow MI services running on the cluster nodes to access Granta MI databases in your SQL instance.

When using SQL authentication for SQL access management (users connect using username and password), a SQL login should be created for use by MI Server, MI Settings Service, and MI Data Flow, and this must be a member of the db_owner fixed-database role on all Granta MI databases.

When using Windows Authentication with Microsoft SQL Server, additional SQL logins are required.

  1. To give the Active Directory Granta MI Service User access to the MIConfig database:
    1. Add a login for the Granta MI Service User account.
    2. Add this login to the db_owner database role on all Granta MI databases in your SQL instance.
  2. To give the MI Settings Service on each node access to the MIConfig database:
    1. Create a computer account login for each node.
      For example, DOMAIN\machine1name$
    2. Add all MI node logins to the db_owner database role on the MIConfig database.
  3. To give MI Data Flow access to the MIDataFlow configuration database, add the machine account for the node where MI Data Flow is installed to the db_owner database role on MIDataFlow.