Questions tagged [contained-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
40 views

Partial Contained Databases

I have a peculiar issue. I have some partial contained DBs that are being used by a CMS system and whenever I go to take a backup of these DBs they do not compress. I do have the server property ...
user avatar
0 votes
1 answer
31 views

Support of SQL Server Containers running on container orchestrators

The Microsoft documentation states the following about the supportability of SQL Server Containers running on container orchestrators: Microsoft supports deploying and managing SQL Server containers ...
user avatar
  • 103
0 votes
0 answers
45 views

AAD users lose access to database after import

I googled for the last few days but I got a bit confused and I do not know how to proceed further. Also, I'm not a DBA and I was just faced with this situation for the first time. Using sqlpackage.exe ...
user avatar
-1 votes
1 answer
74 views

Creating contained users for Azure SQL Database

What's the difference between these two commands? CREATE USER abc FROM EXTERNAL PROVIDER CREATE USER abc FOR EXTERNAL PROVIDER
user avatar
1 vote
1 answer
546 views

Disable password policy for partially-contained database

I'm stuck in a situation where I need to create a new user for a partially-contained database (SQL Server 2016). The password is short, so I get an error: Password validation failed. The password ...
user avatar
  • 13
4 votes
2 answers
304 views

sp_Blitz fails with collation error

SQL Server version (output from select @@VERSION): Microsoft SQL Server 2017 (RTM-CU19) (KB4535007) - 14.0.3281.6 (X64) (Build 14393: ) Installed sp_Blitz from Brent Ozar, stored procedure creates ...
user avatar
  • 85
1 vote
0 answers
33 views

What are the disadvantages of contained database in ms sql 2017

What are the disadvantages of contained database in Microsoft SQL Server 2017? I want to introduce contained database in my organization. I would like to know what limitations exist. Reasons why I ...
user avatar
  • 11
6 votes
1 answer
620 views

SQL Server - How does contained database user password expiration work?

I've recently started working with contained databases and I do not understand if/how contained database users have passwords that expire. MSDN documentation says they do - With a SQL Server login, ...
user avatar
1 vote
0 answers
304 views

Replication Alternatives for Contained Databases

My team and I are in the process of designing a new application using the microservice architecture approach. Each application is going to to be responsible for releasing changes to its own database ...
user avatar
  • 11
0 votes
1 answer
498 views

Contained User within a Non-Contained Azure SQL Database

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 ...
user avatar
  • 132
1 vote
0 answers
55 views

Unlink Windows login from database user in SQL Server contained database

I'm migrating databases from SQL Server 2012 to Server Server 2017, and switching SOME of them to partially contained. I've done SQL Server backups and restores to actually move the databases, and ...
user avatar
3 votes
1 answer
483 views

sp_help_revlogin for contained database users?

I've been using sp_help_revlogin for a long time to transfer server principals from one SQL instance to another. Is there a sp_help_revlogin equivalent that can output create scripts for partially ...
user avatar
  • 9,468
0 votes
1 answer
245 views

Can a contained database SQL User be mapped to a remote user in a linked server?

Using SQL Server 2017 Standard CU8 on Windows Server 2016. I've create a contained database user (user defined only within a database with Containment type: partial) with type SQL user with password (...
user avatar
2 votes
3 answers
896 views

How can I send mail from a contained database is SQL Server?

How can I send mail with a user within a contained database is SQL Server using Database Mail? I tried using msdb.dbo.sp_send_dbmail but since any users local to the contained database do not see ...
user avatar
  • 323
0 votes
1 answer
232 views

SQL Server Partially Contained Databases and Linked Servers

What is the work around for using linked servers with partially contained DBs? Additionally, how would this work with Always on and a secondary replica?
user avatar
1 vote
2 answers
4k views

Azure SQL Database "Login failed for user" contained users.

I'm having a similar issue to this question (https://dba.stackexchange.com/posts/123094/edit)! I have followed the following article: https://azure.microsoft.com/en-gb/documentation/articles/sql-...
user avatar
6 votes
3 answers
6k views

Contained DB Collation error

When changing a database to partially contained I am getting the following error: Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_100_CI_AS_KS_WS_SC" in ...
user avatar
  • 1,529
0 votes
0 answers
2k views

How do I alter containment to none for partially contained db with default language?

Experimented with Contained DBs in an Always-On Availability Group and decided against them. I want to UN-contain the databases now but when I run: alter database <myDB> set containment = NONE ...
user avatar
  • 316
43 votes
2 answers
24k views

How to restore a "contained" database? [closed]

I recently tried to restore to my local development SQL Server a backup from a network instance. To my surprised I received the following error message: Msg 12824, Level 16, State 1, Line 3 The ...
user avatar
  • 1,259