Skip to content

SqlPackage - option to skip Windows logins #426

@yarong-lifemap

Description

@yarong-lifemap
  • SqlPackage or DacFx Version: 162.2.60.1
  • .NET Framework (Windows-only) or .NET Core: .Net 8
  • Environment (local platform and source/target platforms): Windows Server 2022

Steps to Reproduce:

  1. Connect Sql Server to Azure Arc
  2. Try to export a bacpac
  3. Get the following result:
    One or more unsupported elements were found in the schema used as part of a data package.
    Error SQL71627: The element User: [NT AUTHORITY\SYSTEM] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
    Error SQL71627: The element Login: [NT AUTHORITY\SYSTEM] has property IsMappedToWindowsLogin set to a value that is not supported in Microsoft Azure SQL Database v12.

Did this occur in prior versions? If not - which version(s) did it work in?

(DacFx/SqlPackage/SSMS/Azure Data Studio)

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions