Solved

Partially Contained Databases - Connection Strings must be explicit

Posted on 2016-11-19
3
50 Views
Last Modified: 2016-11-22
Hi experts

i am Reading about: Partially Contained Databases - Connection Strings must be explicit
but i do not understand, can you give me an example.
0
Comment
Question by:enrique_aeo
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Vitor Montalvão earned 500 total points
ID: 41895500
That means you always need to provide the database name, user name and password when you're trying to connect to this kind of database.
For a regular database you don't need to provide the database if the user has a default database configured but for a contained database you'll always need to provide it.
0
 

Author Comment

by:enrique_aeo
ID: 41896561
is it advantage? (Connection Strings must be explicit)
0
 
LVL 49

Expert Comment

by:Vitor Montalvão
ID: 41897091
Isn't a matter of being advantage or not. Is the only way it works. You do not have another option for Contained Databases.
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

740 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question