title: Cannot connect to a MSSQL Express 2014 Database using VS 2013 Professional (specifically VB)
body: <p>I read another article concerning this problem when getting the file in use message.  I went into SQL Management studio and disconnected the database but still no success in connecting.  Here's what's happening step by step:</p>
  
  <p>I downloaded SQL Express 2014 and installed it.  I created a DB called MyEntertainmentDB, then created a couple of files (Movies and Rating).  I added some data to both.  I fired up VS and in VB I created a form added various controls including a datagrid.  The DB exists in the default location used by MS SQL.  I clicked the Smart Tag and the data grid view tasks window appears.  I click the choose data source drop down arrow and then add project data source.  Database is highlighted and I click next.  Dataset is highlighted and I click next.  Now I click new connection and select Microsoft SQL Server Database File (Data provider is .NET Framework Data Provider for SQL Server (the only thing in that drop down box)) and I click Continue.  Now I'm shown a window that has the data source as Microsoft SQL Server Database File (SqlClient) in the first box and I browse to where my database is located and select it (which is C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA\MyEntertainmentDB.mdf).  Everything is going well and I'm using Windows Authentication.  I click ok.  Now it waits several minutes and I get this message:</p>
  
  <p>The attempt to attach to the database failed with the following message: 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 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 looked in theSQL Server log but nothing was mentioned shedding any light.  I could not find any VS log.  I checked the windows logs but could not find anything seemingly relevant.  I'm at a loss for this problem and am about ready to trash MS SQL server and just go with MS Access 2010 or MySQL.  Does anybody see where I'm going wrong?  If so, please help, I've tried to be very specific and hope I've provided all info necessary.</p>