July 17, 2024 at 9:38 am
Hello,
I try to migrate SQL on Prem Instances to SQL Managed Instances.
I'm using the DBA Tools Start-dbaMigration.
Everything is working, expect the migration of the Logins.
I get the error: "Domain\User is a Windows Login, not spported on a SQL Managed Instance"
We Sync the Users to the Azure with AD Connect so they exist also in Entra AD.
I think there is a Problem with the Domain Suffix that is not Supported on the Managed Instance.
Is there a way to bypass this error ?
I'm also happy to hear other solutions if there is a better way for migration of the Logins.
Thanks and best regards
BAM
July 17, 2024 at 11:00 am
Logins here will be something you would want to do manually as you can't just simply create
CREATE LOGIN [DOMAIN\Group] FROM WINDOWS
etc, if they are in Entra as Entra is an external provider, so you actually have to do
CREATE LOGIN [Group] FROM EXTERNAL PROVIDER
DBATools can't handle the switching of the type for you, so you would need to use DBATools to script out the logins to a SQL file, then modify that file and find replace, "FROM WINDOWS" to "FROM EXTERNAL PROVIDER" and then get DBATools to execute that modified script or run it manually.
July 17, 2024 at 11:01 am
Logins here will be something you would want to do manually as you can't just simply create
CREATE LOGIN [DOMAIN\Group] FROM WINDOWS
etc, if they are in Entra as Entra is an external provider, so you actually have to do
CREATE LOGIN [Group] FROM EXTERNAL PROVIDER
DBATools can't handle the switching of the type for you, so you would need to use DBATools to script out the logins to a SQL file, then modify that file and find replace, "FROM WINDOWS" to "FROM EXTERNAL PROVIDER" and then get DBATools to execute that modified script or run it manually.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply