title: Connecting to AdventureWorks database (SQL Server 2005 Express) through Visual Studio Professional 2008
body: <p>I am following the <strong><em>learning</em> ASP.NET 3.5</strong> by O'REILLY to write some ASP.NET 3.5 code using Visual Studio 2008 SP1.  I have gotten to the point to where I need to Configure a Data Source using the SqlDataSource control.  I chose <strong>Microsoft SQL Server (SqlClient)</strong> even though I have SQL Server Express 2005 - This seems like the only logical choice.  </p>
  
  <p>I get to the <strong>Add Connection</strong> window and successfully add a <strong>Server name</strong> and I use the <strong>Select or enter a database name</strong> of <strong>AdventureWorks</strong>.  When I click on Test Connection I get the <strong>Test Connection Succeeded</strong> message box.</p>
  
  <p>Unfortunately, when I click OK I get an error message of the following:</p>
  
  <pre><code>Could not load file or assembly 'Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0.0, Culture=neutral,
  PublicKey Token=89845dcd8080cc91' or one of its dependecies.  The system cannot find
  the file specified.
  </code></pre>
  
  <p>At his point I am at a loss and everywhere I look and find something similar to my issue it involves other versions of either Visual Studio or SQL Server.</p>
  
  <p>I'd really appreciate any help on this!</p>