Hi all,
I try to follow this article:
https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/database/dbmovement-scenario-exportuat
When import to DevOps I get this error
*** Error importing database:Could not import package.
Warning SQL0: The source contains users that rely on an external authentication provider that is not supported by the target. These users will be treated as users without logins.
Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 102, Level 16, State 30, Line 1 Incorrect syntax near 'type'.
Error SQL72045: Script execution error. The executed script:
CREATE USER [d365-ops-dbms-prod]
WITH SID = 0xEB044DBB8A256343AD835337BE44B162, TYPE = E;
I usualy export UAT data to bacpac file manual but now I cannot access to UAT DB from SQL Server Management anymore so I used LCS tool, maybe there are some changes from last time I restored data from UAT to DevOps.