Contained Database users

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » Contained Database users

32 posts, Page 1 of 4

1 2 3 4 »»»

Contained Database users

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Wednesday, April 11, 2012 11:43 PM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:56 PM
Points: 31,664, Visits: 16,114

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

Henrico Bekker

Posted Wednesday, April 11, 2012 11:52 PM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 1:02 AM
Points: 1,880, Visits: 2,857

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

Koen Verbeeck

Posted Wednesday, April 11, 2012 11:52 PM

SSChampion

Group: General Forum Members
Last Login: Today @ 8:35 AM
Points: 14,012, Visits: 11,948

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

Stewart "Arturius" Campbell

Posted Thursday, April 12, 2012 2:36 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: 2 days ago @ 12:04 PM
Points: 4,288, Visits: 5,663

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

DugyC

Posted Thursday, April 12, 2012 2:57 AM

Ten 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

Stuart Davies

Posted Thursday, April 12, 2012 4:00 AM

Hall of Fame

Group: General Forum Members
Last Login: Today @ 2:04 AM
Points: 3,461, Visits: 3,772

Another question from Steve on contained databases. I wonder what he has been playing around with?

Wink

-------------------------------
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

Thomas Abraham

Posted Thursday, April 12, 2012 5:40 AM

SSCommitted

Group: General Forum Members
Last Login: Friday, February 20, 2015 4:03 PM
Points: 1,993, Visits: 2,237

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. Wink

Please don't go. The drones need you. They look up to you.
Connect to me on LinkedIn

Post #1282281

mtassin

Posted Thursday, April 12, 2012 7:23 AM

Hall of Fame

Group: General Forum Members
Last Login: Tuesday, February 3, 2015 10:47 AM
Points: 3,688, Visits: 72,436

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

Steve Jones - SSC Editor

Posted Thursday, April 12, 2012 8:13 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:56 PM
Points: 31,664, Visits: 16,114

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

OzYbOi d(-_-)b

Posted Thursday, April 12, 2012 8:29 AM

Ten 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 »

32 posts, Page 1 of 4

1 2 3 4 »»»

Permissions