Microsoft® SQL Server 2012 Unleashed

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.

FIGURE 19.11 ...