Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Contained Database users Expand / Collapse
Author
Message
Posted Wednesday, April 11, 2012 11:43 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 32,771, Visits: 14,935
Comments posted to this topic are about the item Contained Database users






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1282134
Posted Wednesday, April 11, 2012 11:52 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 12:58 AM
Points: 1,904, Visits: 2,771
Good one on 2012 range of QOTD...havent seen too many yet.

----------------------------------------------
Msg 8134, Level 16, State 1, Line 1
Divide by zero error encountered.
Post #1282139
Posted Wednesday, April 11, 2012 11:52 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:51 PM
Points: 12,201, Visits: 9,157
Nice question, always good to learn something new.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1282140
Posted Thursday, April 12, 2012 2:36 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 5:25 AM
Points: 3,683, Visits: 4,817
Good question, thanks, Steve.
Learned something new.


____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1282193
Posted Thursday, April 12, 2012 2:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Wasn't aware of Contained Databases, so learned something new again today.

Great questions, thanks Steve.


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1282202
Posted Thursday, April 12, 2012 4:00 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 1:16 AM
Points: 2,826, Visits: 2,836
Another question from Steve on contained databases. I wonder what he has been playing around with?



-------------------------------
Posting Data Etiquette - Jeff Moden
Smart way to ask a question

There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
Post #1282219
Posted Thursday, April 12, 2012 5:40 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 1,622, Visits: 2,032
Thanks for giving me a reason to do some digging this morning. Learned a lot.

But, it's hard to concentrate, as I'm waiting for Steve to hit 30,000 points - kind of like waiting for your odometer to roll over.



Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn
Post #1282281
Posted Thursday, April 12, 2012 7:23 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 12:05 PM
Points: 3,566, Visits: 72,411
I was aware of what contained databases are...

At first I thought this was a trick question, because if you can't use AD credentials against a contained database then what good are they? After all the best practices recommendation is to use Windows authentication for everything SQL related.

Then I was like, ok so if it's a trick question, why would anybody want to use this? And then I was like, why in the world would you be able to only use groups or users but not both?

Finally I went with my original answer and got it right :) Yay me?




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1282354
Posted Thursday, April 12, 2012 8:13 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 32,771, Visits: 14,935
The AD Credential thing is interesting. If there are matching AD credentials at the instance level, the authentication takes place there first, which makes sense. So if you move a partially contained database to a server that has a matching login, the login isn't contained.

Not a big deal, but interesting.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1282408
Posted Thursday, April 12, 2012 8:29 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
tks Steve
Post #1282420
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse