O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to a Contained Database

Some special considerations apply when connecting to a contained database. This stems from the fact that a contained database cannot have references to elements outside of the scope of the database. This includes references to logins which are scoped at the server level. To address this, a contained user needs to be created within the contained database. To create a contained user, expand the database node in Object Explorer, right-click on Users, and then click on New User. To create a contained SQL Server Authentication user, choose the user type of SQL User Without Login, as shown in Figure 19.11.

Image

FIGURE 19.11 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required