title: Cannot connect to SQL Server Express 2014 from Visual Studio 2012
body: <p>My question is regarding retrieving data from SQL Server (Express 2014) into Visual Studio (Professional 2012).  I am following a tutorial re usage of the drop down list. When I use 'Choose Data Source' I can proceed as far as selecting the database.  When I try to use 'Microsoft SQL Server Database File (SqlClient)' and select 'NORTHWND.MDF' from my App_Data folder I get this error:</p>
  
  <p>The attempt to attach to the database failed with the following information:
  A network-related or instance-specific error occurred while establishing
  an 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. Cannot create an automatic instance. See the Windows
  Application event log for error details.)</p>
  
  <p>I have nothing in the log re this.</p>
  
  <p>When I try and connect to SQL Server using 'Microsoft SQL Server' I can get to the SQL Server Instance, select the database and get 'Connection Successful' but on OK get this error:</p>
  
  <p>Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version 11.0.0.0
  Culture=neutral, Public Key Token=89845dcd8080cc91' or one of its dependencies.
  The system cannot find the file specified.</p>
  
  <p>I have installed SQLLocalDB.</p>
  
  <p>Help greatly appreciated as this is holding up my studies.  Thank you.</p>