Sample Header Ad - 728x90

Contained User within a Non-Contained Azure SQL Database

0 votes
1 answer
654 views
While granting access to Azure SQL databases I have been creating Contained Users directly in the SQL database like so:- CREATE USER [email@domain.com] FROM EXTERNAL PROVIDER; As this has been working fine, and users need to add the database name to the connection, I thought azure would know this is now a contained database. However, upon checking, I've found the database is not contained select containment, containment_desc from sys.databases containment / containment_desc 0 / NONE 0 / NONE Should I now convert the database to be contained? Are there any implications for leaving the database in this state? Should I revert back to creating the user at both the server and DB level?
Asked by Porkster (132 rep)
Jan 31, 2019, 11:51 AM
Last activity: Jan 31, 2019, 12:36 PM