Solved

Partially Contained Databases - Connection Strings must be explicit

Posted on 2016-11-19
3
33 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 46

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 46

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
What should be a storage size for SQL in day1, day2 and day 3 7 82
CROSS APPLY 4 45
SQL Server Question 5 29
Trying to identify overlapping date ranges 5 17
How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now