title: Cannot connect to SQL Server 2008 Error 18456 Login failed for user
body: <p>I'm trying to connect to our SQL Server box from our web server. The only thing i've been able to find regarding the issue is to enable tcp/ip and mixed authentication.</p>
  
  <ol>
  <li>TCP/IP is already enabled </li>
  <li>Mixed authentication mode is selected </li>
  <li>we already have 1 user successfully connecting to a different database so I know TCP/IP and mixed authentication are working.</li>
  <li>Logging in as the problem user from sql manager works fine.</li>
  <li>I get the same error creating an ODBC connection as well as a ColdFusion SQL Server data source.</li>
  </ol>
  
  <p>According to the log files, which isn't logging all the attempts also indicates State 40, which is "Default database could not be accessed (SQL 2008)."
  I've check and the default database is the one I want to open. The Schema is DBO.</p>
  
  <p>Any help would be appreciated.</p>