azurerm_mssql_managed_instance not updating administrator_login_password

[fgarcia-cnb]

Is there an existing issue for this?

• I have searched the existing issues

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or "me too" comments, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

1.0.7

AzureRM Provider Version

3.35.0

Affected Resource(s)/Data Source(s)

azurerm_mssql_managed_instance

Terraform Configuration Files

n/a

Debug Output/Panic Output

n/a

Expected Behaviour

should detect that SQL MI admin password is different than whats in state

Actual Behaviour

password difference not detected. is it an issue with it being a sensitive value?

Steps to Reproduce

build sql mi. change password in the portal. rerun terraform to detect changes

Is the problem that the Azure API cannot retrieve the current password so this parameter only works on creation?

Important Factoids

No response

References

No response

[sinbai]

Hi @fgarcia-cnb it seems that this issue has been fixed by PR and released in Terraform Provider v3.43.0, could you please upgrade the version and try again?

[fgarcia-cnb]

im not sure thats the same issue. if someone changes the password in the azure portal, terraform wont know about it correct? because the api cant refresh the password value? terraform wont detect a drift... i just tested with v3.45.0 and it didnt detect drift