Solved

Partially Contained Databases - Connection Strings must be explicit

Posted on 2016-11-19
3
38 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
  • 2
3 Comments
 
LVL 47

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 47

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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

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…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
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…

786 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