Contents Required SQL Server setupPrint page Required SQL Server setup The following SQL Server setup steps must be completed before installing any Granta MI software.This section contains the following topics:Enabling and configuring FILESTREAM on your SQL instanceFILESTREAM storage is a requirement for MI clusters, enabling nodes to access BLOB data on the cluster's SQL instance. Restoring Granta MI databasesThe database backup files extracted from the Granta MI download package should be restored on your SQL instance by the SQL Database Administrator (DBA) in your organization.Creating Granta MI SQL loginsDepending 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. Enabling FILESTREAM storage on the Miconfig databaseThis topic describes how to configure the Miconfig database on your cluster SQL instance to use FILESTREAM storage. « Generating an Elasticsearch API key for Granta MIEnabling and configuring FILESTREAM on your SQL instance »
