Blog Post

Modernization Best Practices and Reusable Assets Blog
5 MIN READ

Azure SQL Managed Instance – Sync Agent Jobs and Logins in Failover Groups

narenan's avatar
narenan
Icon for Microsoft rankMicrosoft
Oct 21, 2021
Introduction In an Azure SQL Managed Instance setup with Failover Group, the schema, data, and database-level users will always be synced between primary and secondary instance. As of October 2021,...
Updated Jan 05, 2024
Version 4.0
database platform cse
database platform cse – sql
justintjacob's avatar
justintjacob
Copper Contributor
Nov 06, 2024

getting the below error

 

Executed as user: User Manager\ContainerAdministrator. A HASHED password cannot be set for a login that has CHECK_POLICY turned on. [SQLSTATE 42000] (Error 33020)