Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [contained-database]

26 questions
49
votes
2 answers

How to restore a "contained" database?

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 sp_configure value 'contained database…
David
  • 1,399
  • 1
  • 9
  • 12
6
votes
1 answer

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, there's the option box to Enforce Password…
Will Southwood
  • 101
  • 7
6
votes
3 answers

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 the EXCEPT operation. Errors were encountered in the…
Tom
  • 1,569
  • 6
  • 29
  • 43
4
votes
2 answers

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 successfully. Version info from the code: SELECT…
SJWales
  • 109
  • 2
  • 10
3
votes
1 answer

How to tell if SQL Server user is contained?

Scenario and Initial Question Imagine you sit down at the keyboard of an arbitrary SQL Server host (traditional SQL Server, on a machine; not Azure) that you've never used before. You have administrative credentials, and need to assess the security…
manniongeo
  • 130
  • 1
  • 1
  • 10
3
votes
1 answer

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 contained database users? I understand that if I…
user4659
2
votes
2 answers

How to replicate jobs between nodes with SQL Server 2022

I created a contained availability group but I don't know why the jobs are not synchronized between the nodes. What could be the problem? Shouldn't it do it automatically? In response to the answer I have performed the following: I'm connected on…
Marshall
  • 21
  • 2
2
votes
3 answers

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 msdb, therefore msdb.dbo.sp_send_dbmail is…
gemisigo
  • 343
  • 1
  • 3
  • 12
1
vote
0 answers

SQL Backups with SQL 2022 Contained Availability Group

We have a SQL 2022 Always On Availabilty Group with Contained databases; a new feature in this version of SQL. The master and msdb databases are now also in the Avalability Group. We like this setup, for example we only have to maintain the logins…
Jeroen Bleeker
  • 11
  • 2
1
vote
1 answer

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 does not meet Windows policy requirements because it…
Ives
  • 13
  • 1
  • 4
1
vote
0 answers

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 should not implement it would be useful too.
Azirila
  • 11
  • 1
1
vote
0 answers

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 using a tool not unlike flyway…
Gee2113
  • 11
  • 1
1
vote
0 answers

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 switched them to partially contained. When I then…
M Herbener
  • 213
  • 1
  • 8
1
vote
2 answers

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-database-manage-logins/ and just cannot get it to…
Stephen Neal
  • 13
  • 1
  • 4
0
votes
1 answer

Logon Trigger On HA

Here is the setup: on MSSQL-Server-2022, we have a contained availability group with 4 replicas: 3 synchronous, 1 asynchronous, and a listener. We created a logon trigger to limit access to a specific login from only one IP address. The trigger…
Mandana
  • 1
1
2