Creating Granta MI SQL logins

Depending on your preferred 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 the Granta MI databases.

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.