title: How to share SQL LocalDb with other users on same machine?
body: <p>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. </p>
  
  <p>Here are my steps:</p>
  
  <ol>
  <li><p>Login to user  User1 on Windows 7</p></li>
  <li><p>Create a new database called test using sqlcmd as follows</p>
  
  <p>sqlcmd -S (localdb)\v11.0 
  create database test</p></li>
  <li><p>Share the instance v11.0 as follows with User2</p>
  
  <p>sqllocaldb share domain\User2 v11.0 myinstance</p></li>
  <li><p>Switch to User 2</p></li>
  <li><p>Login to shared instance as follows</p>
  
  <p>sqlcmd -S (localdb)\.\myinstance</p>
  
  <p>select name from sys.master_files</p>
  
  <p>The above query does not display test database.</p></li>
  </ol>
  
  <p>Why am I not able to see the databases in User 2 that was created in User1 after sharing?</p>
  
  <p>I thought it must work based on blog (approach 2)<a href="http://blogs.msdn.com/b/sqlexpress/archive/2011/12/09/using-localdb-with-full-iis-part-2-instance-ownership.aspx#SharedLocalDB" rel="noreferrer">http://blogs.msdn.com/b/sqlexpress/archive/2011/12/09/using-localdb-with-full-iis-part-2-instance-ownership.aspx#SharedLocalDB</a> by Krzysztof Kozielczyk but it does not.</p>
  
  <p>Any help/suggestion is appreciated.</p>
  
  <p>Thanks
  Pare</p>