User Instance of SqlLocalDb

localdb
Siddharood picture Siddharood · Dec 27, 2012 · Viewed 16.8k times · Source

I am getting this Exception When I am trying to access database from C#.

My Connection String is 

Data Source=(localdb)\v11.0;integrated security=true;User Instance = true;AttachDbFileName=C:\Users\UserName\Desktop\DB\TestDB3.mdf

Exception is

The user instance login flag is not allowed when connecting to a user instance of SQL Server. The connection will be closed.

Answer

Krzysztof Kozielczyk picture Krzysztof Kozielczyk · Dec 27, 2012

LocalDB instances are all "User Instances", and there's no need to specify User Instance=true in your connection string, in fact it is not even supported (as you can see). Just remove this part and it's going to work fine.

Related questions

ASP.NET 4.5 has not been registered on the Web server

In my Win 7 development machine, and in order to use SQL Express instance instead of the localDB installed by default. I unchecked "Use IIS Express" in my MVC 4 project properties page (Web tab), then I got the following error: ASP.…

Read More
How to connect to LocalDB in Visual Studio Server Explorer?

I can't believe I couldn't find a working solution to this after an hour of searching. I'm following this article on Entity Framework 6.0 which gives a simple walk-through on Code First. I created the project and installed the latest EF …

Read More
What is the connection string for localdb for version 11

I'm trying to do the Code First Walkthrough of the entity framework ( http://blogs.msdn.com/b/adonet/archive/2011/09/28/ef-4-2-code-first-walkthrough.aspx ). I have the latest SQL Server Express and when I check my versions available via command line (…

Read More