Azure-Samples / azure-sql-library-app-blazor

Library app built with SQL Server and Data API builder as backend, and Blazor as frontend.
MIT License
1 stars 3 forks source link

Publishing Dacpac fails with error: You can only create a user with a password in a contained database. #11

Open seantleonard opened 1 week ago

seantleonard commented 1 week ago

DACPAC publishing fails

This issue is for a:

Minimal steps to reproduce

Go to SQL Project in container, and publish DACPAC

Any log messages given by the failure

Deploy dacpac: Failed. Could not deploy package. Error SQL72014: Core Microsoft SqlClient Data Provider: Msg 33233, Level 16, State 1, Line 1 You can only create a user with a password in a contained database. Error SQL72045: Script execution error. The executed script:

Expected/desired behavior

Successful publish