title: SQL Server backend and Access frontend - ODBC Connection to SQL Server native client failed
body: <p>I have a SQL Server 2008 database as a back end and Access as a front end. Is it required to have SQL Server Management Studio installed for Access to connect to the SQL database.</p>
  
  <p>The SQL database is on a server not on my local machine. I just reconfigured my computer and have not installed SQL Server Management Studio yet. I was trying to open the database in Access but I get this error message saying: </p>
  
  <blockquote>
    <p>ODBC Connection to SQL Server Native Client10.0 "<em>Server name</em>" failed.</p>
  </blockquote>
  
  <p>So how can I get Access to connect to the SQL Server database without having SQL Server management studio? </p>