title: Attempting to connect to SQL Server through Crystal Reports
body: <p>I am attempting to connect Crystal reports to a SQL Server database. Here is what I have done so far.</p>
  
  <p><code>File &gt; Log On or Off Server</code></p>
  
  <p><code>Create New Connection &gt; OLE DB (ADO)</code></p>
  
  <p>Under provider I selected <code>Microsoft OLE DB Provider for SQL Server</code> and click next. </p>
  
  <p>I select the server from the drop down list and put in the username and password for the local admin account. I am able to remote to the server using this account. For the database field I have tried to enter the database name and the path to the .mdf for this database. I get the same error either way.</p>
  
  <pre><code>Login failed.
  Details: ADO Error Code: 0x80040e4d
  Source: Microsoft OLE DB Provider for SQL Server
  Description: Login failed for user 'server\admin'.
  SQL State: 42000
  Native Error: 18456 [Database Vendor Code: 18456 ]
  </code></pre>
  
  <p>Crystal Reports version: 14.0.4.738 RTM<br>
  SQL Server 2012</p>
  
  <p>I did find some similar error messages through google, but the situations were different, so it was not helpful.</p>