Data Backup and Recovery Discussions
Following the process described in "How to Configure NLB and ARR with SnapCenter" (https://kb.netapp.com/Advice_and_Troubleshooting/Data_Protection_and_Security/SnapCenter/How_to_configure_NLB_and_ARR_with_SnapCenter) and it work fine with version 4.3.
With version 4.4 the command Enable-smrepositoryhaconfig returns the error message "failed to execute the sql command to set the master configuration the user or password is incorrect"
Running the command Enable-smrepositoryhaconfig subsiquently returns "MySQL High Avaliability is already configured"
Running the next command in the process "set-smrepositoryconfigurationsettings.." return message "username or password not supplied.
The 2 nodes are Windows 2016 in workgroup and on the same subnet.
Thanks in advance for any contributions
See The Solution
Please verify if the user that you entered for the cmdlet open-smconnection, is part of local administrators on both the NLB nodes
Also did you reset the Mysql root password on both the nodes?
Reset MySQL password of both the nodes to the same password by running Set-SmRepositoryPassword cmdlet on both the nodesWe recommend running this command again on both the nodes and perform
Thanks for your reply.
Yes I did run both commands open-smconnection and Set-SmRepositoryPassword on both nodes.
Thank you for your response. At this moment we recommend opening a support case as the issue may need more troubleshooting and log analysis
View solution in original post