Create Azure Listener fails with "Unable to save property changes for The parameter is incorrect"

  • Article

Symptom

When creating a listener for an availability group hosted in Windows Azure virtual machines, the following error may occur.

Unable to save property changes for <cluster resource name> The parameter is incorrect

 

Cause

Creating an availability group listener for an availability group hosted in Azure virtual machines requires special steps for creating the listener. These steps are documented here.

https://msdn.microsoft.com/en-us/library/dn376546.aspx

 As part of creating the Azure listener, Windows cluster requires a special hotfix applied on each virtual machine defined as a Windows cluster node. If the hotfix is not installed, the error described above, occurs when attempting to execute the PowerShell script documented in step 8 of 'Step 4: Create the availability group listener' which instructs you to execute a PowerShell script:

            8.Copy the PowerShell script below into a text editor and set the variables to the values you noted earlier.

 

Resolution

Apply the hotfix as directed on all nodes that are defined in the Windows cluster and that may host the primary replica of the availability group. For more information and to download the fix, see the following article:

 Update enables SQL Server Availability Group Listeners on Windows Server 2008 R2 and Windows Server 2012-based Windows Azure virtual machines

https://support.microsoft.com/kb/2854082

This error occurs because Hotfix KB 2854082 is not installed on the clustered nodes. 

What the fix does

This update enables support for Windows cluster resources connectivity on Windows Server 2008 R2 and Windows Server 2012-based Windows Azure virtual machines. This support enables the SQL Server Availability Group Listeners.