KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am looking for ways to access LocalDb database between users using the share command of sqllocaldb command utility but I cannot see the database created in one user in another. Here are my steps: Login to user User1 on Windows 7 Create a new database called test using sqlcmd as follows sqlcmd -S (localdb)\v11.0 create database test Share the instance v11.0 as follows with User2 sqllocaldb share domain\User2 v11.0 myinstance Switch to User 2 Login to shared instance as follows sqlcmd -S (localdb)\.\myinstance select name from sys.master_files The above query does not display test database. Why am I not able to see the databases in User 2 that was created in User1 after sharing? I thought it must work based on blog (approach 2) http://blogs.msdn.com/b/sqlexpress/archive/2011/12/09/using-localdb-with-full-iis-part-2-instance-ownership.aspx#SharedLocalDB by Krzysztof Kozielczyk but it does not. Any help/suggestion is appreciated. Thanks Pare
Tags (comma-separated)
Save Edits
Cancel