SQL Server to Managed Instance - New managed instance link feature
1
vote
1
answer
521
views
I have been looking at the managed instance link feature.
Specifically, using the DAG feature to replicate a database on SQL Server 2019 Enterprise Edition, to SQL Managed Instance.
I have hit a wall.
- SQL Server 2019 does not support Azure AD logins, only SQL Server 2022 does at the time of writing, and we are not licensed for v2022 :(
- Our end users (non-sysadmins) access the Azure SQL Managed Instance using their Azure AD logins only.
- The replication of the database using managed instance link, from SQL 2019 to MI is one way only, so the SQL MI has only a read only copy of the database (so cannot add \ alter users there).
- The database users on the read\write version of the DB on SQL 2019 are in Domain\User format, which then means that on the SQL MI those same users are not in the required format, user@domain.com, and there is the problem - users on the MI have no access to the read-only copy with their Azure AD logins.
If I want to keep managed instance link, I can't see how to get around this apart from our end users using SQL logins (where I would then script out a created matching SID).
Has anyone got any other thoughts that I might not have considered?
Asked by ILikeToast
(11 rep)
Apr 12, 2023, 10:19 AM
Last activity: Apr 15, 2025, 04:07 AM
Last activity: Apr 15, 2025, 04:07 AM