Setting Microsoft SQL Server parameters after installation
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:
-
# haconf -makerw -
# hatype -modify MSSQL RestartLimit 1 -
# haconf -dump
Related information