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

Published Jan 15 2019 03:57 PM 109 Views
Microsoft
First published on MSDN on May 22, 2014

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.


http://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


http://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.


%3CLINGO-SUB%20id%3D%22lingo-sub-318316%22%20slang%3D%22en-US%22%3ECreate%20Azure%20Listener%20fails%20with%20%22Unable%20to%20save%20property%20changes%20for%20%3CCLUSTER%20resource%3D%22%22%20name%3D%22%22%3E%20The%20parameter%20is%20incorrect%22%3C%2FCLUSTER%3E%3CLINGO-BODY%20id%3D%22lingo-body-318316%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3E%20First%20published%20on%20MSDN%20on%20May%2022%2C%202014%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId-1535005600%22%20id%3D%22toc-hId-1627324928%22%3ESymptom%3C%2FH3%3E%3CBR%20%2F%3E%3CP%3EWhen%20creating%20a%20listener%20for%20an%20availability%20group%20hosted%20in%20Windows%20Azure%20virtual%20machines%2C%20the%20following%20error%20may%20occur.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EUnable%20to%20save%20property%20changes%20for%20%3CCLUSTER%20resource%3D%22%22%20name%3D%22%22%3E%20The%20parameter%20is%20incorrect%3C%2FCLUSTER%3E%3C%2FP%3E%3CBR%20%2F%3E%3CDIV%3E%3CBR%20%2F%3E%3CP%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F68119i7B754C15C5C7FB07%22%20%2F%3E%3C%2FP%3E%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId--1017151361%22%20id%3D%22toc-hId--924832033%22%3ECause%3C%2FH3%3E%3CBR%20%2F%3E%3CP%3ECreating%20an%20availability%20group%20listener%20for%20an%20availability%20group%20hosted%20in%20Azure%20virtual%20machines%20requires%20special%20steps%20for%20creating%20the%20listener.%20These%20steps%20are%20documented%20here.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn376546.aspx%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fmsdn.microsoft.com%2Fen-us%2Flibrary%2Fdn376546.aspx%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3CP%3EAs%20part%20of%20creating%20the%20Azure%20listener%2C%20Windows%20cluster%20requires%20a%20special%20hotfix%20applied%20on%20each%20virtual%20machine%20defined%20as%20a%20Windows%20cluster%20node.%20If%20the%20hotfix%20is%20not%20installed%2C%20the%20error%20described%20above%2C%20occurs%20when%20attempting%20to%20execute%20the%20PowerShell%20script%20documented%20in%20step%208%20of%20'Step%204%3A%20Create%20the%20availability%20group%20listener'%20which%20instructs%20you%20to%20execute%20a%20PowerShell%20script%3A%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E8.Copy%20the%20PowerShell%20script%20below%20into%20a%20text%20editor%20and%20set%20the%20variables%20to%20the%20values%20you%20noted%20earlier.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3C%2FP%3E%3CBR%20%2F%3E%3CH3%20id%3D%22toc-hId-725658974%22%20id%3D%22toc-hId-817978302%22%3EResolution%3C%2FH3%3E%3CBR%20%2F%3E%3CP%3EApply%20the%20hotfix%20as%20directed%20on%20all%20nodes%20that%20are%20defined%20in%20the%20Windows%20cluster%20and%20that%20may%20host%20the%20primary%20replica%20of%20the%20availability%20group.%20For%20more%20information%20and%20to%20download%20the%20fix%2C%20see%20the%20following%20article%3A%3C%2FP%3E%3CBR%20%2F%3E%3CDIV%3E%3CBR%20%2F%3E%3CP%3EUpdate%20enables%20SQL%20Server%20Availability%20Group%20Listeners%20on%20Windows%20Server%202008%20R2%20and%20Windows%20Server%202012-based%20Windows%20Azure%20virtual%20machines%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2854082%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20http%3A%2F%2Fsupport.microsoft.com%2Fkb%2F2854082%20%3C%2FA%3E%3C%2FP%3E%3CBR%20%2F%3E%3C%2FDIV%3E%3CBR%20%2F%3E%3C%2FDIV%3E%3CBR%20%2F%3E%3CP%3EThis%20error%20occurs%20because%20Hotfix%20KB%202854082%20is%20not%20installed%20on%20the%20clustered%20nodes.%3C%2FP%3E%3CBR%20%2F%3E%20What%20the%20fix%20does%20%3CBR%20%2F%3E%3CP%3EThis%20update%20enables%20support%20for%20Windows%20cluster%20resources%20connectivity%20on%20Windows%20Server%202008%20R2%20and%20Windows%20Server%202012-based%20Windows%20Azure%20virtual%20machines.%20This%20support%20enables%20the%20SQL%20Server%20Availability%20Group%20Listeners.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%3C%2FP%3E%0A%20%0A%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-318316%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20MSDN%20on%20May%2022%2C%202014%20SymptomWhen%20creating%20a%20listener%20for%20an%20availability%20group%20hosted%20in%20Windows%20Azure%20virtual%20machines%2C%20the%20following%20error%20may%20occur.%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-318316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Econnectivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EHigh%20Availability%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FLINGO-SUB%3E
Version history
Last update:
‎Jan 15 2019 03:57 PM
Updated by: