We are re-initializing database sync from Azure sql database to on-premise db. Database provisioning failed as bellow for one sync group, while the other group was succeed setup.
From the error, ActiveDirectoryLoginId(nvarchar(max)) was used in an index, but no index was found on our source db. We can manually create follow tables on member db to work round. Anyone know the reason. Thanks.
Database provisioning failed with the exception "SqlException Error Code: -2146232060 - SqlError Number:1919, Message: Column 'ActiveDirectoryLoginId' in table 'dbo.Employee' is of a type that is invalid for use as a key column in an index. For more information, provide tracing ID ‘8fbe0d77-126b-496c-9121-b9ed3c633669’ to customer support."
Another table also failed with similar error. Both of them are nvarchar(max) type, is there anything related to this?