Setting Microsoft SQL Server parameters after installation

Last published : Oct 13, 2026
The service file and mssql.conf file must be updated appropriately as per the Microsoft SQL Server documentation. To ensure that the database is available to client from all the failover nodes in the cluster, the database must be hosted non-promiscuously.
Note: InfoScale does not recommend that you setRestart=on-failurein the service file. Doing so can cause the Microsoft SQL Server to restart on its own. If you need a similar behavior, InfoScale recommends that you use theRestartLimitattribute instead.
Run the following commands to set the RestartLimit attribute:
  1. # haconf -makerw
  2. # hatype -modify MSSQL RestartLimit 1
  3. # haconf -dump