Skip to main content

Questions tagged [contained-database]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
2 answers
95 views

How does this user log in to the database server, when its login is deactivated on the database server?

I've specifically disabled a login on the database server. This is an Azure hosted SQL-as-a-Service database. alter login [********@hotmail.com] disable Here's what the login looks like on the server....
Yossi Geretz's user avatar
0 votes
0 answers
107 views

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, ...
Jeroen Bleeker's user avatar
0 votes
1 answer
54 views

Can SQL Server contained database users use linked servers with login mappings? [duplicate]

Using SQL Server 2022 Standard Edition and contained database users (which means no corresponding SQL login at the instance level). I would like to have the contained database users be able to use a ...
M Herbener's user avatar
0 votes
2 answers
637 views

Unable to connect to Oracle user in pluggable database

for some reason, i am unable to connect with any user that I create. their account status is also unlocked. I want to mention one thing; the pdbs are clone of the main pdb. (as shown by their name ...
dbafix's user avatar
  • 62
3 votes
1 answer
939 views

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 ...
manniongeo's user avatar
2 votes
2 answers
643 views

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 ...
Marshall's user avatar
0 votes
2 answers
564 views

Convert SQL Server user based on login to contained database user based on Windows account

Context We've recently changed our SQL Server security governance to favor users that are: Contained database users, and; Based on Windows domain accounts It's working great for new projects. I need ...
manniongeo's user avatar
0 votes
1 answer
67 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 ...
DBA Ryan's user avatar
0 votes
1 answer
37 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 ...
yborgess's user avatar
  • 103
0 votes
0 answers
101 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 ...
Roxananana's user avatar
-1 votes
1 answer
301 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
Prashant Shekhar's user avatar
1 vote
1 answer
2k 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 ...
Ives's user avatar
  • 13
4 votes
2 answers
447 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 ...
SJWales's user avatar
  • 109
1 vote
0 answers
76 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 ...
Azirila's user avatar
  • 11
6 votes
1 answer
1k 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, ...
Will Southwood's user avatar
1 vote
0 answers
383 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 ...
Gee2113's user avatar
  • 11
0 votes
1 answer
604 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 protected]] FROM EXTERNAL PROVIDER; As this has been ...
Porkster's user avatar
  • 132
1 vote
0 answers
69 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 ...
M Herbener's user avatar
3 votes
1 answer
914 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 ...
Craig Efrein's user avatar
  • 9,660
0 votes
1 answer
355 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 (...
M Herbener's user avatar
2 votes
3 answers
1k 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 ...
gemisigo's user avatar
  • 343
0 votes
1 answer
240 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?
user3099771's 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-...
Stephen Neal's user avatar
6 votes
3 answers
8k 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 ...
Tom's user avatar
  • 1,549
48 votes
2 answers
32k 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 ...
David's user avatar
  • 1,349