Skip to content

Bug: Import fails with error message 'Supplied parameter sid should be binary(16).' when the database has an AAD user associated with an AAD server login #260

@namangupta211

Description

@namangupta211

Try creating a DB on Azure and then creating an AAD user there, create user [xxxxUser@abc.com] from external provider. In SSMS, if we script that user to create, we get this script: CREATE USER [testUser@abc.com] FROM  EXTERNAL PROVIDER  WITH DEFAULT_SCHEMA=[dbo]
but if using sqlpackage to extract and script, we get this: CREATE USER [xxxxUser@abc.xom]
    WITH SID = 0xXXXXXXXXX123456B78XXXX1234XXX, TYPE = E;

Steps to Reproduce:

  1. Try creating a DB on Azure and then creating an AAD user there create user [xxxxUser@abc.com] from external provider.
  2. Use sqlpackage to extract and script, I get this: CREATE USER [xxxxUser@abc.com]
        WITH SID = 0xXXXXXXXXX123456B78XXXX1234XXX, TYPE = E;
  3. Import the bacpac.

**Did this occur in prior versions? yes

(DacFx/SqlPackage)

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions