title: RobotFramework - Connecting to SQL SERVER integrated windows logon
body: <p>I was trying to connect to the SQL Server 2012 database using the robot framework
  for a long time unsuccessfully, finally came up with this</p>
  <h2>*** Settings ***</h2>
  <pre><code>Test Setup   Connect To Database Using Custom Params 
     pymssql     ${server},${username},${password},${databasename},${trusted}
  </code></pre>
  <p>all in a single line with tab spaces inbetween</p>
  <p><strong>Where</strong>
  Test Setup - Is the key word used under Settings for setting up the DB Environment in this case
  Connect To Database Using Custom Params  -- are the keywords to connect to database which are found in the databaselibrary of RobotFramework
  pymssql - Module for connecting with SQLSERVER database</p>
  <p>The below are the parameters to be passed</p>
  <ol>
  <li>server - name of the server in single quote</li>
  <li>username - Username along with the domain name - format - 'domain-name\username'</li>
  <li>Password - self explanatory</li>
  <li>Trusted - The value should be set as 'True'</li>
  </ol>
  <p>This helped me in establishing the connection with sql server 2012, but i still face issues.</p>
  <blockquote>
  <p><strong>Error message</strong>  Setup failed: SyntaxError: EOL while scanning string literal (, line 1)</p>
  </blockquote>