title: ColdFusion 10 Administrator, MS SQL 2012 and Windows 8
body: <p>I've been trying to add a datasource in the ColdFusion Administrator for Windows 8 and I've been having many issues.
  Below is what I've done:</p>
  
  <ol>
  <li>Database created "onessBlog".</li>
  <li>Login created onessBlog with password onessBlog / SQL Server Authentication pointing to default database onessBlog</li>
  <li>User onessBlog created with default schema of dbo.</li>
  <li>Named Pipes enabled for SQLEXPRESS</li>
  <li>TCP/IP - All IP1 to IP11 is Active, Enabled, TCP Dynamic Ports is blank and TCP Port is 1433.</li>
  <li>Service has been restarted.</li>
  </ol>
  
  <p>Under data sources in ColdFusion Administrator, I create a datasource name 1ssBlog with the Microsoft SQL Server.  I filled in the following fields:</p>
  
  <ul>
  <li>CF Data source Name: <code>1ssBlogg</code></li>
  <li>Database: <code>onessBlog</code></li>
  <li>Server:   <code>127.0.0.1</code> and <code>localhost</code></li>
  <li>Port: <code>1433</code></li>
  <li>User name: <code>this is blank</code></li>
  <li>Password: <code>this is also blank</code></li>
  </ul>
  
  <p>Once I verify the connection, I get the following error: <code>Cannot open database "onessBlog" requested by the login. The login failed.</code></p>
  
  <p>I have viewed the following resources and I don't know what I missed:</p>
  
  <ul>
  <li><a href="http://help.adobe.com/en_US/ColdFusion/10.0/Admin/WSc3ff6d0ea77859461172e0811cbf364104-7fe5.html" rel="nofollow noreferrer">Adobe Docs</a></li>
  <li><a href="http://www.mattgifford.co.uk/local-sql-server-2008-coldfusion-datasource" rel="nofollow noreferrer">Local SQL Server 2008 ColdFusion Datasource</a></li>
  <li><a href="https://stackoverflow.com/questions/5475702/how-do-you-configure-a-coldfusion-8-datasource-to-connect-to-a-local-sql-server">How do you configure a ColdFusion 8 datasource to connect to a local SQL Server 2008 server?</a></li>
  </ul>