It would have been helpful to know what prerequisites are required for a command to run successfully. For example,
-- Run this on each server instance participating in the AG.
EXEC sp_configure 'hadr enabled', 1;
RECONFIGURE;
returned
Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62 [Batch Start Line 9]
The configuration option 'hadr enabled' does not exist, or it may be an advanced option.
It was not in Advanced Options. In documentation, I found this T-SQL code instead:
SELECT SERVERPROPERTY ('IsHadrEnabled');
and becomes enabled either in Management Studio or in PowerShell with
Enable-SqlAlwaysOn -Path SQLSERVER:\SQL\Computer\Instance
- This reply was modified 4 months, 3 weeks ago by andre.quitta.