Contents Required SQL Server setupPrint page Required SQL Server setup The following topics cover required SQL setup for a Granta MI cluster. These steps must be completed before installing any Granta MI software.This section contains the following topics:High availability for SQL ServerTo provide high availability for SQL Server services in an HA Granta MI cluster, you will need to implement a SQL HA solution.Restoring Granta MI databasesThe database backup files extracted from the Granta MI download package should be restored in SQL Server by the SQL Database Administrator (DBA) in your organization.Creating Granta MI SQL loginsDepending 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. Configuring FILESTREAM storage in SQL ServerFILESTREAM is a requirement where data storage for your MI cluster is provided by Microsoft SQL Server running on on-premises servers or in Azure virtual machines.Database configuration for FILESTREAM dataWhere data storage for your MI cluster is provided by Microsoft SQL Server running on on-premises servers or in Azure virtual machines, the Miconfig database must be configured to use FILESTREAM storage. « Generating an Elasticsearch API key for Granta MIHigh availability for SQL Server »
