Error: Database already in use

[we|rd0]

The db provided by Microsoft is already attached to SQL Server Management Studio. I was querying on it like:-

select * from Person.Person

When I tried to connect the same db from MS visual Studio 2012/2014 by going in Tools-> Connect to Database. It gave the error:Database is already in use.

I know it is possible to access a db both from front end and back end at the same time. What settings do i need to apply?

[Erland Sommarskog]

Post by we|rd0
The db provided by Microsoft is already attached to SQL Server
Management Studio. I was querying on it like:-
select * from Person.Person
When I tried to connect the same db from MS visual Studio 2012/2014 by
going in Tools-> Connect to Database. It gave the error:Database is
already in use.
I know it is possible to access a db both from front end and back end at
the same time. What settings do i need to apply?

You might be better off asking in a Visual Studio forum. I am under the
impression that VS uses the option AttachDBFilename to attach it to a
different instance.