title: How to allow IIS to use local database from ASP.NET MVC project?
body: <p>I'm going to be demoing a ASP.NET MVC website on a local network. This application has a connection to a database:</p>
  
  <pre><code>&lt;connectionStrings&gt;
      &lt;add name="DefaultConnection" connectionString="Data Source=(LocalDb)\v11.0;AttachDbFilename=|DataDirectory|\aspnet-EBC-20141127093222.mdf;Initial Catalog=aspnet-EBC-20141127093222;Integrated Security=True" providerName="System.Data.SqlClient" /&gt;
  &lt;/connectionStrings&gt;
  </code></pre>
  
  <p><strong>I would like if this database can be used by both IIS and whenever I run my application locally.</strong> I've made a site on IIS - it is running .NET v4. My project lives in <code>c:\inetpub\www\ebc</code>. I can publish the website but recieve this error upon viewing the page:</p>
  
  <hr>
  
  <p>"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 50 - Local Database Runtime error occurred. Unexpected error occurred inside a LocalDB instance API method call. See the Windows Application event log for error details."</p>
  
  <p>I know I need to allow remote connections to the sql server through microsoft sql server manager? Is there a way to do it elsewhere?</p>