I'm running on an M1 chip, I have Azure SQL Edge in docker, and I'm trying to create a database from a .bacpac file in Azure Data Studio. I get this error when I try:
The sp_configure value 'contained database authentication' must be set to 1 in order to alter a contained database. You may need to use RECONFIGURE to set the value_in_use.
However, when I run:
sp_configure 'contained database authentication', 1;
GO
RECONFIGURE;
GO
I get a new error:
Started executing query at Line 1 Msg 15392, Level 16, State 1, Procedure sp_configure, Line 166
The specified option 'contained database authentication' is not supported by this edition of SQL Server and cannot be changed using sp_configure.
Does anyone have an idea of what I can do instead?
So it turns out that I can install 2019 sql server in docker, despite multiple other online sources saying it's not compatible with my machine. I guess that other information was outdated and misleading, and then I was able to run: sp_configure and all my problems were solved.