Questions tagged [contained-database]
The contained-database tag has no usage guidance.
13
questions
1
vote
0answers
17 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 ...
5
votes
1answer
110 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, ...
0
votes
0answers
158 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 ...
0
votes
1answer
229 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 ...
1
vote
0answers
27 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 ...
2
votes
1answer
251 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 ...
0
votes
1answer
120 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 (...
2
votes
3answers
680 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 ...
0
votes
1answer
199 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?
1
vote
2answers
2k 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-...
4
votes
3answers
3k 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 ...
0
votes
0answers
1k 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
...
24
votes
2answers
13k 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 ...
