Changing database connection settings

Use the MI Server Connection tool and MI Service Layer Configuration tool to view or change the SQL database connection settings specified during installation on your MI Pro application server.

Settings that enable the MI Server and MI Settings Service applications to access the MIConfig database in SQL Server are specified during product installation.

If your SQL Server details change after Granta MI Pro is installed, for example, if the name of the server hosting SQL Server changes, or if the SQL Server access management method is changed, you will need to update the database connection details stored in the MI Server application and in the MI Settings Service as follows, using the Windows client tools installed on your Granta MI Pro application server.

MI Server database connection settings

You can view and modify the settings used by MI Server to connect to the MIConfig database in SQL Server on the Database tab of the MI Server Connection tool.

  • SQL Server: the name of the SQL Server instance or Azure SQL Database.
  • Connect using: the method used by the Granta MI application server to authenticate to the SQL Server, either Windows Authentication or SQL authentication. For SQL authentication, specify the username and password for a SQL login on your SQL Server instance or Azure SQL Database.
  • Configuration database: the MIConfig database in SQL Server.
  • Advanced: options for fine-tuning connection configuration properties, for example timeout settings. See the Help for the MI Server Connection tool for details.
  • The Blob (unstructured data) storage field is not used in MI Pro, and can be ignored.

After making any changes, click Save changes & restart service.

Settings Service database connection settings

You can view and modify the settings used by the Settings Service to connect to the MIConfig database in SQL Server in the MI Settings Service Configuration tool.

  • MI Settings Service URL: the location of the Settings Service
  • SQL Server: the name of the SQL Server instance or Azure SQL Database
  • Connect using: the method used by the Settings Service to authenticate to the SQL Server, either Windows Authentication or SQL authentication. For SQL authentication, you must specify the username and password for a SQL login on your SQL Server instance or Azure SQL Database.
  • Configuration database: the MIConfig database in SQL Server.
  • Advanced: options for fine-tuning connection configuration properties, for example timeout settings.

After making any changes, click Test to check that the Settings Service can access the config database using the specified settings. Click Save to save any changes.