title: "Type 'System.Data.SqlClient.SqlConnection' is not defined." in .Net Web Site
body: <p>I'm trying to get a .NET web site running on a network server, and while everything is set up and running locally on my machine (using IISExpress), when I deploy to a Windows Server 2008 server with IIS installed, I end up getting compilation errors when trying to use an SqlConnection:</p>
  <blockquote>
  <p>Compiler Error Message: BC30002: Type 'System.Data.SqlClient.SqlConnection' is not defined.</p>
  </blockquote>
  <p>Now, I have both import statements at the beginning of the source file as follows:</p>
  <blockquote>
  <p>Imports System.Data.SqlClient</p>
  <p>Imports System.Data</p>
  </blockquote>
  <p>In the compilation warnings it lists a very strange error:</p>
  <blockquote>
  <p>Warning: BC40056: Namespace or type specified in the Imports 'System.Data.SqlClient' doesn't contain any public member or cannot be found. Make sure the namespace or the type is defined and contains at least one public member. Make sure the imported element name doesn't use any aliases.</p>
  </blockquote>
  <p>Evidently, the compiler can't find System.Data.SqlClient. The IIS application pool is running .NET 2.0, and my site is targeting 3.5. I'm very new to .NET development, and I'm learning this as I go, but this has me stuck. Am I missing a dependency? Do I need SQL Server Management Studio installed on the server?</p>